APPS.PKG_GMP_BUCKET_DATA dependencies on MTL_SYSTEM_ITEMS

Line 527: /* akaruppa changed the cursor to obtain the UOM from MTL_SYSTEM_ITEMS

523: CURSOR Get_ord_ind_cur IS
524: SELECT order_ind
525: FROM ps_schd_hdr
526: WHERE schedule_id = V_schedule;
527: /* akaruppa changed the cursor to obtain the UOM from MTL_SYSTEM_ITEMS
528: CURSOR Cur_item_um IS
529: SELECT item_um, item_um2
530: FROM ic_item_mst
531: WHERE item_id = V_item_id; */

Line 535: FROM mtl_system_items

531: WHERE item_id = V_item_id; */
532:
533: CURSOR Cur_item_um IS
534: SELECT DISTINCT primary_uom_code,secondary_uom_code
535: FROM mtl_system_items
536: WHERE inventory_item_id = V_item_id;
537:
538: CURSOR Cur_schedule IS
539: SELECT no_days, no_weeks, no_4weeks, no_13weeks

Line 654: ' mtl_system_items msi '||

650: ' FROM '||
651: ' gme_batch_header gbh, '||
652: ' gme_material_details gmd, '||
653: ' mtl_parameters mp, '||
654: ' mtl_system_items msi '||
655: ' WHERE '||
656: ' Gbh.batch_id = gmd.batch_id '||
657: ' AND msi.inventory_item_id = gmd.inventory_item_id '||
658: ' AND msi.organization_id = gmd.organization_id '||

Line 687: ' mtl_system_items items,'||

683: ' ) trans_qty, '||
684: ' org.organization_code '|| -- akaruppa previously iwm.whse_code
685: ' FROM '||
686: ' mtl_demand_omoe mtl,'||
687: ' mtl_system_items items,'||
688: ' oe_order_headers_all hdr, '||
689: ' oe_order_lines_all dtl, '||
690: ' mtl_parameters org '||
691: ' WHERE '||

Line 748: ' mtl_system_items msi, '||

744: ' FROM '||
745: ' ps_schd_for psf, '||
746: ' mrp_forecast_designators mff, '||
747: ' mrp_forecast_dates dtl, '||
748: ' mtl_system_items msi, '||
749: ' mtl_parameters mp '||
750: ' WHERE dtl.inventory_item_id = :p11 '||
751: ' AND psf.schedule_id = :p12 '||
752: ' AND INSTR(:p13, TO_CHAR(psf.organization_id)) <> 0 '||

Line 783: ' MTL_SYSTEM_ITEMS mitem '||

779: ' ) trans_qty, '||
780: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
781: ' FROM MTL_PARAMETERS mtl, '||
782: ' PO_PO_SUPPLY_VIEW po, '||
783: ' MTL_SYSTEM_ITEMS mitem '||
784: ' WHERE po.item_id = :p16 '|| -- akaruppa previously ic.item_id
785: ' AND po.item_id = mitem.inventory_item_id '||
786: ' AND po.to_organization_id = mitem.organization_id '||
787: ' AND mtl.organization_id = po.to_organization_id '||

Line 813: ' MTL_SYSTEM_ITEMS mitem '||

809: ' ) trans_qty, '||
810: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
811: ' FROM MTL_PARAMETERS mtl,'||
812: ' PO_REQ_SUPPLY_VIEW po,'||
813: ' MTL_SYSTEM_ITEMS mitem '||
814: ' WHERE po.item_id = :p20'|| -- akaruppa previously ic.item_id
815: ' AND po.item_id = mitem.inventory_item_id '||
816: ' AND po.to_organization_id = mitem.organization_id '||
817: ' AND mtl.organization_id = po.to_organization_id '||

Line 844: ' MTL_SYSTEM_ITEMS mitem '||

840: ' ) trans_qty, '||
841: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
842: ' FROM MTL_PARAMETERS mtl,'||
843: ' PO_RCV_SUPPLY_VIEW po,'||
844: ' MTL_SYSTEM_ITEMS mitem '||
845: ' WHERE po.item_id = :p24'|| -- akaruppa previously ic.item_id
846: ' AND po.item_id = mitem.inventory_item_id '||
847: ' AND po.to_organization_id = mitem.organization_id '||
848: ' AND mtl.organization_id = po.to_organization_id '||

Line 874: ' MTL_SYSTEM_ITEMS mitem '||

870: ' ) trans_qty, '||
871: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
872: ' FROM MTL_PARAMETERS mtl,'||
873: ' PO_SHIP_RCV_SUPPLY_VIEW po, '||
874: ' MTL_SYSTEM_ITEMS mitem '||
875: ' WHERE po.item_id = :p28'|| -- akaruppa previously ic.item_id
876: ' AND po.item_id = mitem.inventory_item_id '||
877: ' AND po.to_organization_id = mitem.organization_id '||
878: ' AND mtl.organization_id = po.to_organization_id '||

Line 904: ' FROM MTL_SYSTEM_ITEMS mitem,'||

900: ' NULL '||
901: ' ) '||
902: ' ) trans_qty, '||
903: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
904: ' FROM MTL_SYSTEM_ITEMS mitem,'||
905: ' PO_SHIP_SUPPLY_VIEW po,'||
906: ' MTL_PARAMETERS mtl '||
907: ' WHERE po.item_id = :p32'|| -- akaruppa previously ic.item_id
908: ' AND po.item_id = mitem.inventory_item_id '||