eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVIDIT3 dependencies on MTL_SUPPLY

Line 343: FROM mtl_supply

339: END IF;
340:
341: IF (material_org_count <> 1) THEN
342: SELECT count(1) INTO material_org_count
343: FROM mtl_supply
344: WHERE item_id = p_item_id
345: AND (from_organization_id = p_org_id OR to_organization_id = p_org_id)
346: AND rownum = 1;
347:

Line 349: --we need to check for records in MTL_Supply with supply_type_code

345: AND (from_organization_id = p_org_id OR to_organization_id = p_org_id)
346: AND rownum = 1;
347:
348: --bug 7155924(7327865,7327866): for lot and serial control attributes
349: --we need to check for records in MTL_Supply with supply_type_code
350: --in Receiving and Shipment only
351: SELECT count(1) INTO material_org_count_ls
352: FROM mtl_supply
353: WHERE item_id = p_item_id

Line 352: FROM mtl_supply

348: --bug 7155924(7327865,7327866): for lot and serial control attributes
349: --we need to check for records in MTL_Supply with supply_type_code
350: --in Receiving and Shipment only
351: SELECT count(1) INTO material_org_count_ls
352: FROM mtl_supply
353: WHERE item_id = p_item_id
354: AND (from_organization_id = p_org_id
355: OR to_organization_id = p_org_id)
356: and supply_type_code in ('RECEIVING', 'SHIPMENT')

Line 393: FROM mtl_supply ms

389:
390: --3713912 :check for pending transactions such as approved PO
391: IF (material_master_count <> 1) THEN
392: SELECT COUNT(1) INTO material_master_count
393: FROM mtl_supply ms
394: WHERE ms.item_id = p_item_id
395: AND EXISTS (SELECT 1
396: FROM mtl_parameters
397: WHERE master_organization_id = p_master_org

Line 402: --we need to check for records in MTL_Supply with supply_type_code

398: AND (organization_id = ms.from_organization_id OR organization_id = ms.to_organization_id))
399: AND rownum = 1;
400:
401: --bug 7155924(7327865,7327866): for lot and serial control attributes
402: --we need to check for records in MTL_Supply with supply_type_code
403: --in Receiving and Shipment only
404: SELECT COUNT(1)
405: INTO material_master_count_ls
406: FROM mtl_supply ms

Line 406: FROM mtl_supply ms

402: --we need to check for records in MTL_Supply with supply_type_code
403: --in Receiving and Shipment only
404: SELECT COUNT(1)
405: INTO material_master_count_ls
406: FROM mtl_supply ms
407: WHERE ms.item_id = p_item_id
408: AND EXISTS (SELECT 1
409: FROM mtl_parameters
410: WHERE master_organization_id = p_master_org

Line 588: from mtl_supply

584: -- Start bug 4387538
585: if (lot_level = 2 or serial_level = 2) then
586: select count(1)
587: into l_intr_ship_org
588: from mtl_supply
589: where supply_type_code = 'SHIPMENT'
590: and item_id = p_item_id
591: and to_organization_id = p_org_id
592: and from_organization_id is not null

Line 600: from mtl_supply

596:
597: if (lot_level = 1 or serial_level = 1) then
598: select count(1)
599: into l_intr_ship_master
600: from mtl_supply
601: where supply_type_code = 'SHIPMENT'
602: and item_id = p_item_id
603: and to_organization_id in
604: (select organization_id

Line 633: from mtl_supply

629: if (rev_level = 2 or stockable_level = 2 or lot_level = 2 or serial_level = 2) then
630:
631: select count(1)
632: into l_org
633: from mtl_supply
634: where supply_type_code in ('RECEIVING', 'SHIPMENT')
635: and item_id = p_item_id
636: and to_organization_id =p_org_id
637: and rownum =1 ;

Line 645: from mtl_supply

641: if (rev_level = 1 or stockable_level = 1 or lot_level = 1 or serial_level = 1 ) then
642:
643: select count(1)
644: into l_master
645: from mtl_supply
646: where supply_type_code in ('RECEIVING', 'SHIPMENT')
647: and item_id = p_item_id
648: and to_organization_id in
649: (select organization_id

Line 839: from mtl_supply ms

835: from rcv_shipment_headers rsh, rcv_shipment_lines rsl
836: where rsh.shipment_header_id = rsl.shipment_header_id
837: and rsh.receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')
838: and exists (select 1
839: from mtl_supply ms
840: where ms.shipment_header_id = rsh.shipment_header_id
841: and ms.item_id = rsl.item_id -- bug 13538019
842: and ms.shipment_line_id = rsl.shipment_line_id
843: and ms.supply_type_code in ('SHIPMENT', 'RECEIVING'))

Line 855: from mtl_supply ms

851: from rcv_shipment_headers rsh, rcv_shipment_lines rsl
852: where rsh.shipment_header_id = rsl.shipment_header_id
853: and rsh.receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')
854: and exists (select 1
855: from mtl_supply ms
856: where ms.shipment_header_id = rsh.shipment_header_id
857: and ms.item_id = rsl.item_id -- bug 13538019
858: and ms.shipment_line_id = rsl.shipment_line_id
859: and ms.supply_type_code in ('SHIPMENT', 'RECEIVING'))