APPS.EAM_AUTOMATICEST dependencies on PO_DISTRIBUTIONS_ALL

Line 447: FROM PO_DISTRIBUTIONS_ALL pda , PO_LINE_TYPES plt ,

443: nvl( plt.outside_operation_flag, 'N' )
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

Line 507: FROM PO_DISTRIBUTIONS_ALL pda , PO_REQUISITION_LINES_ALL prla

503: l_stmt_num := 70;
504:
505: SELECT prla.line_location_id
506: INTO l_line_location_id
507: FROM PO_DISTRIBUTIONS_ALL pda , PO_REQUISITION_LINES_ALL prla
508: WHERE pda.line_location_id = nvl( prla.line_location_id , -999 )
509: AND pda.po_distribution_id = p_po_dist_id ;
510:
511: EXCEPTION

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;