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 1004: AND supply_source_type_id = inv_reservation_global.g_source_type_rcv

1000: INTO l_xdock_criterion_id,
1001: l_expected_delivery_time
1002: FROM mtl_reservations
1003: WHERE demand_source_line_detail = l_backorder_delivery_detail_id
1004: AND supply_source_type_id = inv_reservation_global.g_source_type_rcv
1005: AND organization_id = l_org_id
1006: AND inventory_item_id = l_inventory_item_id;
1007: EXCEPTION
1008: WHEN OTHERS THEN

Line 1493: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

1489: -- and used for reservation queries.
1490:
1491: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1492:
1493: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1494: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1495: l_prim_qty NUMBER;
1496: l_primary_temp_qty NUMBER;
1497: l_prim_uom VARCHAR2(3);

Line 1507: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;

1503: l_qty_succ_reserved NUMBER;
1504: l_msg_data VARCHAR2(2400);
1505: l_msg_count NUMBER;
1506:
1507: l_dummy_sn INV_Reservation_Global.Serial_Number_Tbl_Type;
1508:
1509: l_source_header_id NUMBER;
1510: l_source_line_id NUMBER;
1511: l_rev varchar2(3);

Line 1524: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;

1520: l_transfer_lpn_id NUMBER;
1521: l_serial_number VARCHAR2(30);
1522: l_transaction_source_type_id NUMBER;
1523: l_txn_supply_source_id NUMBER;
1524: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1525: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1526: l_rsv_tbl_count NUMBER;
1527: l_error_code NUMBER;
1528:

Line 1525: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1521: l_serial_number VARCHAR2(30);
1522: l_transaction_source_type_id NUMBER;
1523: l_txn_supply_source_id NUMBER;
1524: l_query_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1525: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1526: l_rsv_tbl_count NUMBER;
1527: l_error_code NUMBER;
1528:
1529: l_order_source_id NUMBER;

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

1709: -- but creation/transfer of reservation should still happen correctly.
1710: -- }}
1711:
1712: --IF(l_lpn_context <> 3 )THEN
1713: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1714: IF (l_debug = 1) THEN
1715: mydebug('Create Rsv');
1716: END IF;
1717:

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

1756: -- for a given supply source id then transfer reservation else create
1757: -- reservation
1758: l_query_rsv_rec.organization_id := l_org_id;
1759: l_query_rsv_rec.inventory_item_id := l_item_id;
1760: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1761: -- LPN coming from WIP
1762: l_query_rsv_rec.supply_source_header_id := l_txn_supply_source_id;
1763: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
1764: ELSE -- LPN coming from Receiving

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

1759: l_query_rsv_rec.inventory_item_id := l_item_id;
1760: IF (l_transaction_source_type_id = inv_reservation_global.g_source_type_wip) THEN
1761: -- LPN coming from WIP
1762: l_query_rsv_rec.supply_source_header_id := l_txn_supply_source_id;
1763: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
1764: ELSE -- LPN coming from Receiving
1765:
1766: -- Bug# 3281512 - Performance Fixes
1767: -- Take the decode out of the query and just use an IF condition

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

1779: WHEN OTHERS THEN
1780: l_query_rsv_rec.supply_source_header_id := -1;
1781: END;
1782:
1783: l_query_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_po;
1784: END IF;
1785: l_query_rsv_rec.demand_source_header_id := l_mso_header_id;
1786: l_query_rsv_rec.demand_source_line_id := l_demand_info.oe_line_id;
1787:

Line 1797: p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc,

1793: x_msg_count => l_msg_count,
1794: x_msg_data => l_msg_data,
1795: p_query_input => l_query_rsv_rec,
1796: p_lock_records => fnd_api.g_true,
1797: p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc,
1798: x_mtl_reservation_tbl => l_reservation_tbl,
1799: x_mtl_reservation_tbl_count => l_rsv_tbl_count,
1800: x_error_code => l_error_code);
1801:

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

1835: l_primary_temp_qty;
1836: l_primary_temp_qty := 0;
1837: END IF;
1838:
1839: l_update_rsv_rec.supply_source_type_id := INV_Reservation_GLOBAL.g_source_type_inv;
1840: l_update_rsv_rec.supply_source_header_id := NULL;
1841: l_update_rsv_rec.supply_source_line_id := NULL;
1842: l_update_rsv_rec.supply_source_name := NULL;
1843: l_update_rsv_rec.supply_source_line_detail := NULL;

Line 1894: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order

1890: l_update_rsv_rec.inventory_item_id := l_item_id;
1891:
1892: If l_order_source_id = 10 then
1893: l_update_rsv_rec.demand_source_type_id :=
1894: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
1895: ELSE
1896: l_update_rsv_rec.demand_source_type_id :=
1897: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1898: end if;

Line 1897: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry

1893: l_update_rsv_rec.demand_source_type_id :=
1894: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
1895: ELSE
1896: l_update_rsv_rec.demand_source_type_id :=
1897: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1898: end if;
1899: -- bug 2808892
1900: --l_update_rsv_rec.demand_source_type_id := inv_globals.G_SourceType_SalesOrder;
1901: --INV_Reservation_Global.g_source_type_oe; -- order entry

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

1897: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
1898: end if;
1899: -- bug 2808892
1900: --l_update_rsv_rec.demand_source_type_id := inv_globals.G_SourceType_SalesOrder;
1901: --INV_Reservation_Global.g_source_type_oe; -- order entry
1902: l_update_rsv_rec.demand_source_name := NULL;
1903: l_update_rsv_rec.demand_source_header_id := l_mso_header_id;
1904: l_update_rsv_rec.demand_source_line_id := l_demand_info.oe_line_id;
1905: l_update_rsv_rec.demand_source_delivery := NULL;

Line 1916: INV_Reservation_GLOBAL.g_source_type_inv;

1912: l_update_rsv_rec.autodetail_group_id := NULL;
1913: l_update_rsv_rec.external_source_code := NULL;
1914: l_update_rsv_rec.external_source_line_id := NULL;
1915: l_update_rsv_rec.supply_source_type_id :=
1916: INV_Reservation_GLOBAL.g_source_type_inv;
1917: l_update_rsv_rec.supply_source_header_id := NULL;
1918: l_update_rsv_rec.supply_source_line_id := NULL;
1919: l_update_rsv_rec.supply_source_name := NULL;
1920: l_update_rsv_rec.supply_source_line_detail := NULL;

Line 2853: IF l_txn_src_type_id = inv_reservation_global.g_source_type_wip THEN

2849: --task cancellation ELSE call cancel_operation_plan api.
2850:
2851: mydebug('CANCEL_CROSSDOCK_TASK: Call the appropriate API...');
2852:
2853: IF l_txn_src_type_id = inv_reservation_global.g_source_type_wip THEN
2854: mydebug('CANCEL_CROSSDOCK_TASK: Cancelling Crossdock task for a WIP LPN');
2855: cancel_wip_crossdock_task(p_transaction_temp_id => p_transaction_temp_id
2856: ,p_move_order_line_id => l_move_order_line_id
2857: ,x_return_status => x_return_status