[Home] [Help]
2818:
2819: -- calculate g_mtrl_tbl(i).PRIMARY_QUANTITY
2820: SELECT primary_uom_code
2821: INTO l_primary_uom_code
2822: FROM mtl_system_items
2823: WHERE organization_id = g_mtrl_tbl(i)
2824: .organization_id
2825: AND inventory_item_id = g_mtrl_tbl(i).inventory_item_id;
2826:
4221:
4222: BEGIN
4223: SELECT primary_uom_code
4224: INTO l_primary_uom
4225: FROM mtl_system_items
4226: WHERE organization_id = l_mo_line.organization_id
4227: AND inventory_item_id = l_mo_line.inventory_item_id;
4228: EXCEPTION
4229: WHEN no_data_found THEN
7559: MSI.PICK_UOM_CODE,
7560: MSIB.PRIMARY_UOM_CODE) AS CONVERSION_RATE,
7561: MSI.PICKING_ORDER
7562: from MTL_SECONDARY_INVENTORIES MSI,
7563: MTL_SYSTEM_ITEMS_B MSIB,
7564: mtl_onhand_quantities_Detail moqd
7565: WHERE MSIB.organization_id = l_org_id
7566: and MSIB.INVENTORY_ITEM_ID = l_item_id
7567: AND MSI.PICK_UOM_CODE IS NOT NULL
9052: l_organization_id
9053: FROM mtl_material_transactions_temp mmtt,
9054: mtl_item_locations mil,
9055: mtl_secondary_inventories msi,
9056: mtl_system_items item
9057: WHERE mmtt.transaction_temp_id = l_mmtt_tbl(i)
9058: AND mmtt.locator_id = mil.inventory_location_id(+)
9059: AND mmtt.organization_id = mil.organization_id(+)
9060: AND mmtt.subinventory_code = msi.secondary_inventory_name
13138: elsif cur_rec.parameter_id IN (5001, 5002, 5003, 5004, 2001, 5005) then
13139: --ITEM
13140: if v_item_flag = 'N' then
13141: g_Unreleased_SQL := g_Unreleased_SQL ||
13142: ',MTL_SYSTEM_ITEMS_B MSIB ';
13143: g_WHERE_SQL := g_WHERE_SQL ||
13144: ' WDD.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID AND ';
13145: end if;
13146: v_item_flag := 'Y';
18154: OE_ORDER_LINES_ALL OOL,
18155: wms_wp_wave_headers_b WWH,
18156: WMS_WP_WAVE_LINES WWL,
18157: WSH_NEW_DELIVERIES WND,
18158: MTL_SYSTEM_ITEMS_KFV MSIV,
18159: WSH_CARRIERS WC,
18160: MTL_PARAMETERS MP,
18161: WMS_LICENSE_PLATE_NUMBERS WLPN,
18162: WSH_DELIVERY_ASSIGNMENTS WDA,
18359: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18360: (SELECT LICENSE_PLATE_NUMBER
18361: FROM WMS_LICENSE_PLATE_NUMBERS
18362: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18363: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18364: (SELECT LICENSE_PLATE_NUMBER
18365: FROM WMS_LICENSE_PLATE_NUMBERS
18366: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18367: WDT.DISPATCHED_TIME,
18379: mmtt.transaction_quantity
18380: FROM mtl_material_transactions_temp mmtt,
18381: WSH_DELIVERY_DETAILS WDD,
18382: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18383: mtl_system_items_kfv msiv,
18384: wms_op_plans_vl wopv,
18385: per_all_people_f pap,
18386: wms_op_operation_instances wooi,
18387: WMS_WP_WAVE_LINES WWL,
18490: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18491: (SELECT LICENSE_PLATE_NUMBER
18492: FROM WMS_LICENSE_PLATE_NUMBERS
18493: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18494: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18495: (SELECT LICENSE_PLATE_NUMBER
18496: FROM WMS_LICENSE_PLATE_NUMBERS
18497: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18498: WDT.DISPATCHED_TIME,
18511: FROM mtl_material_transactions_temp mmtt,
18512: mtl_material_transactions_temp mmtt2, --12736677
18513: WSH_DELIVERY_DETAILS WDD,
18514: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18515: mtl_system_items_kfv msiv,
18516: wms_op_plans_vl wopv,
18517: per_all_people_f pap,
18518: wms_op_operation_instances wooi,
18519: WMS_WP_WAVE_LINES WWL,
18640: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18641: (SELECT LICENSE_PLATE_NUMBER
18642: FROM WMS_LICENSE_PLATE_NUMBERS
18643: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18644: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18645: (SELECT LICENSE_PLATE_NUMBER
18646: FROM WMS_LICENSE_PLATE_NUMBERS
18647: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18648: WDT.DISPATCHED_TIME,
18659: mmtt.transaction_uom,
18660: mmtt.transaction_quantity
18661: FROM mtl_material_transactions_temp mmtt,
18662: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18663: mtl_system_items_kfv msiv,
18664: wms_op_plans_vl wopv,
18665: per_all_people_f pap,
18666: wms_op_operation_instances wooi,
18667: WMS_WP_WAVE_LINES WWL,
18823: abs(mmt.transaction_quantity)
18824: FROM mtl_material_transactions mmt,
18825: WSH_DELIVERY_DETAILS WDD,
18826: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18827: mtl_system_items_kfv msiv,
18828: wms_op_plans_vl wopv,
18829: per_all_people_f pap,
18830: wms_op_operation_instances wooi,
18831: WMS_WP_WAVE_LINES WWL,
18977: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18978: (SELECT LICENSE_PLATE_NUMBER
18979: FROM WMS_LICENSE_PLATE_NUMBERS
18980: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18981: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18982: (SELECT LICENSE_PLATE_NUMBER
18983: FROM WMS_LICENSE_PLATE_NUMBERS
18984: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18985: WDT.DISPATCHED_TIME,
18997: mmtt.transaction_quantity
18998: FROM mtl_material_transactions_temp mmtt,
18999: WSH_DELIVERY_DETAILS WDD,
19000: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
19001: mtl_system_items_kfv msiv,
19002: wms_op_plans_vl wopv,
19003: per_all_people_f pap,
19004: wms_op_operation_instances wooi,
19005: WMS_WP_WAVE_LINES WWL,
19156: abs(wdth.transaction_quantity)
19157: FROM
19158: WSH_DELIVERY_DETAILS WDD,
19159: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
19160: mtl_system_items_kfv msiv,
19161: wms_op_plans_vl wopv,
19162: per_all_people_f pap,
19163: wms_op_operation_instances wooi,
19164: WMS_WP_WAVE_LINES WWL,