DBA Data[Home] [Help]

APPS.PA_CMT_UTILS dependencies on PO_LINES_ALL

Line 969: from po_lines_all po_line,

965: If p_po_dist is not null and p_forqty = 'Y' then
966:
967: select nvl(pll.matching_basis, 'QUANTITY') /* modified for bug bug 3496492 */
968: into l_po_line_type
969: from po_lines_all po_line,
970: po_distributions_all po_dist,
971: po_line_locations_all pll
972: where Po_dist.distribution_type <> 'PREPAYMENT'
973: and pll.po_line_id = po_line.po_line_id

Line 1303: po_lines_all pol

1299: into l_flag,g_accrue_on_receipt_flag
1300: from
1301: mtl_system_items msi ,
1302: po_distributions_all pod,
1303: po_lines_all pol
1304: where
1305: msi.inventory_item_id=pol.item_id
1306: and pol.po_line_id=pod.po_line_id
1307: and pod.po_distribution_id = p_po_dist_id;