DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on PO_LINES_ALL

Line 1533: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;

1529: l_quantity_received NUMBER;
1530: l_direct_item_id NUMBER;
1531: l_uom VARCHAR2(3);
1532: l_conversion_rate NUMBER := 0;
1533: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;
1534:
1535:
1536: BEGIN
1537:

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

1600: l_item_description,
1601: l_need_by_date,
1602: l_order_type_lookup_code
1603:
1604: from rcv_transactions rct, po_lines_all pla, po_line_types plt,
1605: po_line_locations_all plla, wip_operations wo
1606: where pla.po_header_id (+) = rct.po_header_id
1607: and pla.po_line_id (+) = rct.po_line_id
1608: and rct.po_line_location_id = plla.line_location_id (+)

Line 1628: po_lines_all pol,

1624:
1625: select sum( nvl(pd.quantity_delivered, 0) )
1626: into l_quantity_received
1627: from
1628: po_lines_all pol,
1629: po_distributions_all pd,
1630: po_line_types plt
1631: where
1632: pol.po_line_id = pd.po_line_id

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

1760: select sum(round(inv_convert.inv_um_convert(0,38,quantity_received,
1761: uom_code,l_uom, NULL,NULL),3))
1762: into l_quantity_received
1763: from (SELECT uom.uom_code, sum(pda.quantity_delivered) quantity_received
1764: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda
1765: WHERE pda.destination_type_code = 'SHOP FLOOR' AND (pda.PO_RELEASE_ID IS NOT NULL OR pda.DISTRIBUTION_TYPE = 'STANDARD')
1766: AND pla.line_type_id = plt.line_type_id
1767: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N' AND pla.po_line_id = pda.po_line_id
1768: AND pla.unit_meas_lookup_code = uom.unit_of_measure (+)