DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 1079: FROM mtl_system_items

1075: SELECT lot_control_code
1076: , serial_number_control_code
1077: INTO l_lot_control_code
1078: , l_serial_control_code
1079: FROM mtl_system_items
1080: WHERE inventory_item_id = p_inventory_item_id
1081: AND organization_id = p_organization_id;
1082:
1083: IF (l_lot_control_code > 1 OR l_serial_control_code > 1) THEN

Line 1334: from mtl_system_items

1330: -- this. This would also not be a right assumption for non English cases
1331: --
1332: select primary_uom_code
1333: into l_primary_uom_code
1334: from mtl_system_items
1335: where organization_id = p_organization_id
1336: and inventory_item_id = p_inventory_item_id
1337: and serial_number_control_code in (2,5,6);
1338:

Line 1653: from mtl_system_items

1649: -- One time fetch of item's primary uom code
1650: -- Fetching revision control for bug 3134272
1651: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
1652: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
1653: from mtl_system_items
1654: where organization_id = l_organization_id
1655: and inventory_item_id = l_inventory_item_id;
1656:
1657: -- dbms_output.put_line('main_process_po: Fetched item primary uom code');

Line 2067: from mtl_system_items

2063: -- One time fetch of item's primary uom code
2064: -- Fetching revision control for bug 3134272
2065: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
2066: into l_primary_uom_code,l_revision_control, l_rtv_sec_uom --OPM Convergence
2067: from mtl_system_items
2068: where organization_id = l_organization_id
2069: and inventory_item_id = l_inventory_item_id;
2070:
2071: -- dbms_output.put_line('main_process_intransit: Fetched item primary uom code');

Line 2481: from mtl_system_items

2477: -- One time fetch of item's primary uom code
2478: -- Fetching revision control for bug 3134272
2479: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
2480: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
2481: from mtl_system_items
2482: where organization_id = l_organization_id
2483: and inventory_item_id = l_inventory_item_id;
2484:
2485: -- dbms_output.put_line('main_process_rma: Fetched item primary uom code');

Line 2889: from mtl_system_items

2885: -- One time fetch of item's primary uom code
2886: -- Fetching revision control for bug 3134272
2887: select primary_uom_code,revision_qty_control_code, secondary_uom_code --OPM Convergence
2888: into l_primary_uom_code,l_revision_control, l_sec_uom_code --OPM Convergence
2889: from mtl_system_items
2890: where organization_id = l_organization_id
2891: and inventory_item_id = l_inventory_item_id;
2892:
2893: -- dbms_output.put_line('main_process_receipt: Fetched item primary uom code');

Line 3404: ,mtl_system_items msi

3400: ,rcv_shipment_lines rsl
3401: ,rcv_transactions rt
3402: ,po_line_locations pll
3403: ,po_lines pol
3404: ,mtl_system_items msi
3405: ,mtl_customer_items mci
3406: ,oe_order_lines_all oel
3407: WHERE rt.transaction_id = l_rcv_transaction_id
3408: AND rt.transaction_type <> 'UNORDERED'