DBA Data[Home] [Help]

APPS.EAM_AUTOMATICEST dependencies on PO_LINE_TYPES

Line 286: PO_LINE_TYPES plt

282: INTO l_auth_status , l_dest_type ,
283: l_cancel_flag , l_wip_entity_id ,
284: l_osp
285: FROM PO_REQUISITION_LINES_ALL prla , PO_REQUISITION_HEADERS_ALL prha ,
286: PO_LINE_TYPES plt
287: WHERE prla.requisition_line_id = p_req_line_id
288: AND prla.requisition_header_id = prha.requisition_header_id
289: AND prla.line_type_id = plt.line_type_id;
290:

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