DBA Data[Home] [Help]

APPS.PA_CMT_UTILS dependencies on PO_LINES_ALL

Line 858: from po_lines_all po_line,

854: If p_po_dist is not null and p_forqty = 'Y' then
855:
856: select nvl(pll.matching_basis, 'QUANTITY') /* modified for bug bug 3496492 */
857: into l_po_line_type
858: from po_lines_all po_line,
859: po_distributions_all po_dist,
860: po_line_locations_all pll
861: where Po_dist.distribution_type <> 'PREPAYMENT'
862: and pll.po_line_id = po_line.po_line_id

Line 1192: po_lines_all pol

1188: into l_flag,g_accrue_on_receipt_flag
1189: from
1190: mtl_system_items msi ,
1191: po_distributions_all pod,
1192: po_lines_all pol
1193: where
1194: msi.inventory_item_id=pol.item_id
1195: and pol.po_line_id=pod.po_line_id
1196: and pod.po_distribution_id = p_po_dist_id;