APPS.EAM_AUTOMATICEST dependencies on PO_LINES_ALL

Line 448: PO_LINES_ALL pla , PO_HEADERS_ALL pha

444: INTO l_auth_status , l_dest_type ,
445: l_cancel_flag , l_wip_entity_id ,
446: l_osp
447: FROM PO_DISTRIBUTIONS_ALL pda , PO_LINE_TYPES plt ,
448: PO_LINES_ALL pla , PO_HEADERS_ALL pha
449: WHERE pda.po_line_id = pla.po_line_id
450: AND pla.line_type_id = plt.line_type_id
451: AND pda.po_distribution_id = p_po_dist_id
452: AND pda.po_header_id = pha.po_header_id ;

Line 568: FROM PO_DISTRIBUTIONS_ALL pda , PO_LINES_ALL pla

564: SELECT pda.quantity_ordered , nvl( pda.rate , 0 ) ,
565: nvl( pla.unit_price,0)
566: INTO l_req_qty_p , l_rate_p ,
567: l_unit_price_p
568: FROM PO_DISTRIBUTIONS_ALL pda , PO_LINES_ALL pla
569: WHERE pda.wip_entity_id = l_wip_entity_id
570: AND pda.po_distribution_id = p_po_dist_id
571: AND pda.po_line_id = pla.po_line_id;
572:

Line 634: FROM PO_LINES_ALL pla , PO_DISTRIBUTIONS_ALL pda

630: IF ( p_po_line_id IS NOT NULL ) THEN
631:
632: SELECT pda.po_distribution_id BULK COLLECT
633: INTO l_po_dist_tbl
634: FROM PO_LINES_ALL pla , PO_DISTRIBUTIONS_ALL pda
635: WHERE pla.po_line_id = p_po_line_id
636: AND pla.po_line_id = pda.po_line_id ;
637:
638: l_stmt_num := 20;