APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on PO_LINE_TYPES

Line 1535: from rcv_transactions rct, po_lines_all pla, po_line_types plt,

1531: l_item_description,
1532: l_need_by_date,
1533: l_order_type_lookup_code
1534:
1535: from rcv_transactions rct, po_lines_all pla, po_line_types plt,
1536: po_line_locations_all plla, wip_operations wo
1537: where pla.po_header_id (+) = rct.po_header_id
1538: and pla.po_line_id (+) = rct.po_line_id
1539: and rct.po_line_location_id = plla.line_location_id (+)

Line 1558: po_line_types plt

1554: into l_quantity_received
1555: from
1556: po_lines_all pol,
1557: po_distributions_all pd,
1558: po_line_types plt
1559: where
1560: pol.po_line_id = pd.po_line_id
1561: AND pol.line_type_id = plt.line_type_id
1562: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N'

Line 1697: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda

1693: select sum(round(inv_convert.inv_um_convert(0,38,quantity_received,
1694: uom_code,l_uom, NULL,NULL),3))
1695: into l_quantity_received
1696: from (SELECT uom.uom_code, sum(pda.quantity_delivered) quantity_received
1697: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda
1698: WHERE pda.destination_type_code = 'SHOP FLOOR' AND pla.line_type_id = plt.line_type_id
1699: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N' AND pla.po_line_id = pda.po_line_id
1700: AND pla.unit_meas_lookup_code = uom.unit_of_measure (+)
1701: AND upper(nvl(pla.cancel_flag, 'N')) <> 'Y' AND pla.item_description = l_item_description