Pessoal,<\/div>\n

Bom dia, tudo bem?<\/div>\n

<\/div>\n

Estou montando um select que traga todas as requisi\u00e7\u00f5es em aberto que n\u00e3o possuam ordem de compra (o select das ordens farei em outra ocasi\u00e3o).<\/div>\n

Estou utilizando o line_location_id da po_requisitions_lines_all para checar se h\u00e1 ordens para a requisi\u00e7\u00e3o.<\/div>\n

\nGostaria de consultar o pessoal de PO, se est\u00e1 correto.<\/div>\n

Segue o select abaixo:\u00a0<\/div>\n

\n<\/div>\n

— Requisicoes de Compras<\/font><\/div>\n

\n<\/font><\/div>\n

select pha.segment1,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pla.line_num,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pha.creation_date,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0msi.segment1||’-‘||msi.segment2,<\/span>\n<\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0msi.description,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pha.authorization_status,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pla.quantity,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pla.quantity_delivered,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0pla.quantity_received,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0<\/span>\n<\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/font><\/div>\n

from apps.po_requisition_headers_all pha,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0apps.po_requisition_lines_all pla,<\/font><\/div>\n

\u00a0 \u00a0 \u00a0 \u00a0apps.mtl_system_items_b msi<\/span>\n<\/div>\n

<\/font><\/div>\n

where \u00a0pha.requisition_header_id = pla.requisition_header_id\u00a0<\/font><\/div>\n

\u00a0 \u00a0and \u00a0pla.item_id \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = msi.inventory_item_id\u00a0<\/span><\/div>\n

\u00a0 \u00a0and \u00a0msi.organization_id \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= nvl(pla.destination_organization_id,0)<\/font><\/div>\n

\u00a0 \u00a0and \u00a0pha.cancel_flag \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0is null \u00a0<\/font><\/div>\n

\u00a0 \u00a0and \u00a0pha.authorization_status \u00a0= ‘APPROVED’<\/span>\n<\/div>\n

\u00a0 \u00a0and \u00a0pla.cancel_flag \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = ‘N’<\/font><\/div>\n

\u00a0 \u00a0and \u00a0pha.closed_code \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 is null\u00a0<\/font><\/div>\n

\u00a0 \u00a0and pla.line_location_id \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 is null \u00a0–nao traz requisicoes que tenham OC<\/span><\/div>\n

\n
<\/span><\/div>\n

<\/span><\/div>\n

\n\u200bObrigado<\/span><\/div>\n<\/div>\n

<\/div>\n

\n\u200b<\/div>\n

<\/div>\n

— <\/p>\n

Amilcar Leme<\/div>\n

cel. (19) 9152-5121<\/div>\n

e-mail: amilleme@gmail.com<\/a><\/div>\n

\u00a0<\/div>\n<\/div>\n<\/p><\/div>\n

__._,_.___<\/div>\n

<\/div>\n

Posted by: Amilcar Campos Leme <amilleme@gmail.com>\n <\/p><\/div>\n

<\/div>\n

Reply via web post<\/a><\/p>\n

•<\/p>\n

\n Reply to sender <\/a><\/p>\n

•<\/p>\n

\n Reply to group <\/a><\/p>\n

•<\/p>\n

Start a New Topic<\/a><\/p>\n

•<\/p>\n

Messages in this topic<\/a>
\n (1)<\/p>\n

Visit Your Group<\/a><\/span><\/p>\n

New Members<\/a><\/span>
\n 2<\/span><\/p><\/div>\n

\n $\"Yahoo!$ <\/a><\/p>\n

• Privacy<\/a> • Unsubscribe<\/a> • Terms of Use<\/a> <\/div>\n<\/div>\n

<\/p><\/div>\n