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.WMS_CROSS_DOCK_PVT dependencies on INV_RESERVATION_GLOBAL

Line 729: AND supply_source_type_id = inv_reservation_global.g_source_type_rcv

725: INTO l_xdock_criterion_id,
726: l_expected_delivery_time
727: FROM mtl_reservations
728: WHERE demand_source_line_detail = l_backorder_delivery_detail_id
729: AND supply_source_type_id = inv_reservation_global.g_source_type_rcv
730: AND organization_id = l_org_id
731: AND inventory_item_id = l_inventory_item_id;
732: EXCEPTION
733: WHEN OTHERS THEN

Line 1218: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

1214: -- and used for reservation queries.
1215:
1216: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1217:
1218: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1219: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1220: l_prim_qty NUMBER;
1221: l_primary_temp_qty NUMBER;
1222: l_prim_uom VARCHAR2(3);

Line 1232: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;

1228: l_qty_succ_reserved NUMBER;
1229: l_msg_data VARCHAR2(2400);
1230: l_msg_count NUMBER;
1231:
1232: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
1233:
1234: l_source_header_id NUMBER;
1235: l_source_line_id NUMBER;
1236: l_rev varchar2(3);

Line 1249: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

1245: l_transfer_lpn_id NUMBER;
1246: l_serial_number VARCHAR2(30);
1247: l_transaction_source_type_id NUMBER;
1248: l_txn_supply_source_id NUMBER;
1249: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1250: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1251: l_rsv_tbl_count NUMBER;
1252: l_error_code NUMBER;
1253:

Line 1250: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1246: l_serial_number VARCHAR2(30);
1247: l_transaction_source_type_id NUMBER;
1248: l_txn_supply_source_id NUMBER;
1249: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1250: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1251: l_rsv_tbl_count NUMBER;
1252: l_error_code NUMBER;
1253:
1254: l_order_source_id NUMBER;

Line 1422: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN

1418: -- but creation/transfer of reservation should still happen correctly.
1419: -- }}
1420:
1421: --IF(l_lpn_context <> 3 )THEN
1422: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1423: IF (l_debug = 1) THEN
1424: mydebug('Create Rsv');
1425: END IF;
1426:

Line 1464: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN

1460: -- for a given supply source id then transfer reservation else create
1461: -- reservation
1462: l_query_rsv_rec.organization_id := l_org_id;
1463: l_query_rsv_rec.inventory_item_id := l_item_id;
1464: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1465: -- LPN coming from WIP
1466: l_query_rsv_rec.supply_source_header_id := l_txn_supply_source_id;
1467: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
1468: ELSE -- LPN coming from Receiving

Line 1467: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;

1463: l_query_rsv_rec.inventory_item_id := l_item_id;
1464: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1465: -- LPN coming from WIP
1466: l_query_rsv_rec.supply_source_header_id := l_txn_supply_source_id;
1467: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
1468: ELSE -- LPN coming from Receiving
1469:
1470: -- Bug# 3281512 - Performance Fixes
1471: -- Take the decode out of the query and just use an IF condition

Line 1487: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_po;

1483: WHEN OTHERS THEN
1484: l_query_rsv_rec.supply_source_header_id := -1;
1485: END;
1486:
1487: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_po;
1488: END IF;
1489: l_query_rsv_rec.demand_source_header_id := l_mso_header_id;
1490: l_query_rsv_rec.demand_source_line_id := l_demand_info.oe_line_id;
1491:

Line 1501: p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc,

1497: x_msg_count => l_msg_count,
1498: x_msg_data => l_msg_data,
1499: p_query_input => l_query_rsv_rec,
1500: p_lock_records => fnd_api.g_true,
1501: p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc,
1502: x_mtl_reservation_tbl => l_reservation_tbl,
1503: x_mtl_reservation_tbl_count => l_rsv_tbl_count,
1504: x_error_code => l_error_code);
1505:

Line 1543: l_update_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;

1539: l_primary_temp_qty;
1540: l_primary_temp_qty := 0;
1541: END IF;
1542:
1543: l_update_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;
1544: l_update_rsv_rec.supply_source_header_id := NULL;
1545: l_update_rsv_rec.supply_source_line_id := NULL;
1546: l_update_rsv_rec.supply_source_name := NULL;
1547: l_update_rsv_rec.supply_source_line_detail := NULL;

Line 1594: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order

1590: l_update_rsv_rec.inventory_item_id := l_item_id;
1591:
1592: If l_order_source_id = 10 then
1593: l_update_rsv_rec.demand_source_type_id :=
1594: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
1595: ELSE
1596: l_update_rsv_rec.demand_source_type_id :=
1597: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1598: end if;

Line 1597: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry

1593: l_update_rsv_rec.demand_source_type_id :=
1594: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
1595: ELSE
1596: l_update_rsv_rec.demand_source_type_id :=
1597: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1598: end if;
1599: -- bug 2808892
1600: --l_update_rsv_rec.demand_source_type_id := inv_globals.G_SourceType_SalesOrder;
1601: --INV_Reservation_Global.g_source_type_oe; -- order entry

Line 1601: --INV_Reservation_Global.g_source_type_oe; -- order entry

1597: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1598: end if;
1599: -- bug 2808892
1600: --l_update_rsv_rec.demand_source_type_id := inv_globals.G_SourceType_SalesOrder;
1601: --INV_Reservation_Global.g_source_type_oe; -- order entry
1602: l_update_rsv_rec.demand_source_name := NULL;
1603: l_update_rsv_rec.demand_source_header_id := l_mso_header_id;
1604: l_update_rsv_rec.demand_source_line_id := l_demand_info.oe_line_id;
1605: l_update_rsv_rec.demand_source_delivery := NULL;

Line 1616: INV_Reservation_GLOBAL.g_source_type_inv;

1612: l_update_rsv_rec.autodetail_group_id := NULL;
1613: l_update_rsv_rec.external_source_code := NULL;
1614: l_update_rsv_rec.external_source_line_id := NULL;
1615: l_update_rsv_rec.supply_source_type_id :=
1616: INV_Reservation_GLOBAL.g_source_type_inv;
1617: l_update_rsv_rec.supply_source_header_id := NULL;
1618: l_update_rsv_rec.supply_source_line_id := NULL;
1619: l_update_rsv_rec.supply_source_name := NULL;
1620: l_update_rsv_rec.supply_source_line_detail := NULL;

Line 2497: IF l_txn_src_type_id = inv_reservation_global.g_source_type_wip THEN

2493: --task cancellation ELSE call cancel_operation_plan api.
2494:
2495: mydebug('CANCEL_CROSSDOCK_TASK: Call the appropriate API...');
2496:
2497: IF l_txn_src_type_id = inv_reservation_global.g_source_type_wip THEN
2498: mydebug('CANCEL_CROSSDOCK_TASK: Cancelling Crossdock task for a WIP LPN');
2499: cancel_wip_crossdock_task(p_transaction_temp_id => p_transaction_temp_id
2500: ,p_move_order_line_id => l_move_order_line_id
2501: ,x_return_status => x_return_status