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_XDOCK_PEGGING_PUB dependencies on INV_RESERVATION_GLOBAL

Line 415: AND supply_source_type_id = inv_reservation_global.g_source_type_wip);

411: AND inventory_item_id = p_inventory_item_id
412: AND demand_source_type_id = p_demand_type_id
413: AND demand_source_header_id = p_demand_header_id
414: AND demand_source_line_id = p_demand_line_id
415: AND supply_source_type_id = inv_reservation_global.g_source_type_wip);
416: EXCEPTION
417: WHEN OTHERS THEN
418: -- This should be when no reservations are found
419: RETURN 'N';

Line 469: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip

465: AND inventory_item_id = p_inventory_item_id
466: AND demand_source_type_id = p_demand_type_id
467: AND demand_source_header_id = p_demand_header_id
468: AND demand_source_line_id = p_demand_line_id
469: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip
470: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv);
471: EXCEPTION
472: WHEN OTHERS THEN
473: -- This should be when no reservations are found

Line 470: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv);

466: AND demand_source_type_id = p_demand_type_id
467: AND demand_source_header_id = p_demand_header_id
468: AND demand_source_line_id = p_demand_line_id
469: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip
470: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv);
471: EXCEPTION
472: WHEN OTHERS THEN
473: -- This should be when no reservations are found
474: RETURN 'N';

Line 813: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

809: l_rsv_uom_code2 IN OUT NOCOPY VARCHAR2,
810: l_primary_uom_code IN OUT NOCOPY VARCHAR2,
811: l_conversion_rate IN OUT NOCOPY NUMBER,
812: l_conversion_precision IN NUMBER,
813: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
814: l_rsv_id IN OUT NOCOPY NUMBER,
815: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
816: l_split_wdd_id IN OUT NOCOPY NUMBER,
817: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,

Line 815: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

811: l_conversion_rate IN OUT NOCOPY NUMBER,
812: l_conversion_precision IN NUMBER,
813: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
814: l_rsv_id IN OUT NOCOPY NUMBER,
815: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
816: l_split_wdd_id IN OUT NOCOPY NUMBER,
817: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,
818: l_demand_expected_time IN OUT NOCOPY DATE,
819: l_supply_expected_time IN OUT NOCOPY DATE,

Line 820: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

816: l_split_wdd_id IN OUT NOCOPY NUMBER,
817: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,
818: l_demand_expected_time IN OUT NOCOPY DATE,
819: l_supply_expected_time IN OUT NOCOPY DATE,
820: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
821: l_split_rsv_id IN OUT NOCOPY NUMBER,
822: l_rsv_qty IN OUT NOCOPY NUMBER,
823: l_rsv_qty2 IN OUT NOCOPY NUMBER,
824: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

Line 824: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

820: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
821: l_split_rsv_id IN OUT NOCOPY NUMBER,
822: l_rsv_qty IN OUT NOCOPY NUMBER,
823: l_rsv_qty2 IN OUT NOCOPY NUMBER,
824: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
825: l_supply_type_id IN OUT NOCOPY NUMBER,
826: x_return_status IN OUT NOCOPY VARCHAR2,
827: x_msg_count IN OUT NOCOPY NUMBER,
828: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 1527: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

1523: l_supply_expected_time IN OUT NOCOPY DATE,
1524: l_demand_expected_time IN OUT NOCOPY DATE,
1525: l_demand_project_id IN OUT NOCOPY NUMBER,
1526: l_demand_task_id IN OUT NOCOPY NUMBER,
1527: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1528: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1529: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1530: l_quantity_reserved IN OUT NOCOPY NUMBER,
1531: l_quantity_reserved2 IN OUT NOCOPY NUMBER,

Line 1528: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

1524: l_demand_expected_time IN OUT NOCOPY DATE,
1525: l_demand_project_id IN OUT NOCOPY NUMBER,
1526: l_demand_task_id IN OUT NOCOPY NUMBER,
1527: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1528: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1529: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1530: l_quantity_reserved IN OUT NOCOPY NUMBER,
1531: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
1532: l_rsv_id IN OUT NOCOPY NUMBER,

Line 1529: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

1525: l_demand_project_id IN OUT NOCOPY NUMBER,
1526: l_demand_task_id IN OUT NOCOPY NUMBER,
1527: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1528: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1529: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1530: l_quantity_reserved IN OUT NOCOPY NUMBER,
1531: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
1532: l_rsv_id IN OUT NOCOPY NUMBER,
1533: x_return_status IN OUT NOCOPY VARCHAR2,

Line 2144: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv

2140: WHERE organization_id = l_organization_id
2141: AND inventory_item_id = l_inventory_item_id
2142: AND demand_source_type_id = l_demand_type_id
2143: AND demand_source_line_id = l_demand_line_id
2144: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv
2145: AND NVL(crossdock_flag, 'N') = 'N'
2146: AND primary_reservation_quantity - NVL(detailed_quantity, 0) > 0
2147: FOR UPDATE SKIP LOCKED; --Bug 6813492
2148:

Line 2420: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2416: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
2417: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
2418:
2419: -- Variables to split and update reservations records
2420: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2421: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2422: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2423: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2424: l_split_rsv_id NUMBER;

Line 2421: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2417: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
2418:
2419: -- Variables to split and update reservations records
2420: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2421: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2422: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2423: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2424: l_split_rsv_id NUMBER;
2425:

Line 2422: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2418:
2419: -- Variables to split and update reservations records
2420: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2421: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2422: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2423: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2424: l_split_rsv_id NUMBER;
2425:
2426: -- Variables to call the pregenerate API when MOL records are crossdocked

Line 2423: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

2419: -- Variables to split and update reservations records
2420: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2421: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2422: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2423: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2424: l_split_rsv_id NUMBER;
2425:
2426: -- Variables to call the pregenerate API when MOL records are crossdocked
2427: -- to existing reservations.

Line 6725: supply_source_type_id = inv_reservation_global.g_source_type_rcv)

6721: FROM mtl_reservations
6722: WHERE organization_id = l_organization_id
6723: AND inventory_item_id = l_inventory_item_id
6724: AND ((p_lpn_context = 3 AND -- RCV supply
6725: supply_source_type_id = inv_reservation_global.g_source_type_rcv)
6726: OR
6727: (p_lpn_context = 2 AND -- WIP supply
6728: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6729: supply_source_header_id = p_wip_entity_id))

Line 6728: supply_source_type_id = inv_reservation_global.g_source_type_wip AND

6724: AND ((p_lpn_context = 3 AND -- RCV supply
6725: supply_source_type_id = inv_reservation_global.g_source_type_rcv)
6726: OR
6727: (p_lpn_context = 2 AND -- WIP supply
6728: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6729: supply_source_header_id = p_wip_entity_id))
6730: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip
6731: AND demand_source_line_detail IS NULL
6732: AND NVL(crossdock_flag, 'N') = 'N'

Line 6730: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip

6726: OR
6727: (p_lpn_context = 2 AND -- WIP supply
6728: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6729: supply_source_header_id = p_wip_entity_id))
6730: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip
6731: AND demand_source_line_detail IS NULL
6732: AND NVL(crossdock_flag, 'N') = 'N'
6733: AND primary_reservation_quantity - NVL(detailed_quantity, 0) > 0
6734: FOR UPDATE SKIP LOCKED;

Line 6876: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

6872: l_orig_wdd_values_rec orig_wdd_values_rec;
6873: l_error_code VARCHAR2(3);
6874:
6875: -- Variables to split and update reservations records
6876: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6877: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6878: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6880: l_split_rsv_id NUMBER;

Line 6877: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

6873: l_error_code VARCHAR2(3);
6874:
6875: -- Variables to split and update reservations records
6876: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6877: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6878: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6880: l_split_rsv_id NUMBER;
6881:

Line 6878: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

6874:
6875: -- Variables to split and update reservations records
6876: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6877: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6878: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6880: l_split_rsv_id NUMBER;
6881:
6882: -- Variables to store the available to reserve quantity for a demand or supply line

Line 6879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

6875: -- Variables to split and update reservations records
6876: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6877: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6878: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6879: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6880: l_split_rsv_id NUMBER;
6881:
6882: -- Variables to store the available to reserve quantity for a demand or supply line
6883: -- both in the primary and demand/supply line UOM.

Line 7068: AND supply_source_type_id = inv_reservation_global.g_source_type_wip

7064: SELECT DISTINCT demand_source_type_id, demand_source_header_id, demand_source_line_id
7065: FROM mtl_reservations
7066: WHERE organization_id = l_organization_id
7067: AND inventory_item_id = l_inventory_item_id
7068: AND supply_source_type_id = inv_reservation_global.g_source_type_wip
7069: AND supply_source_header_id = l_supply_header_id;
7070:
7071: -- Table to store the results from the existing WIP reservations cursor
7072: TYPE existing_wip_rsvs_tb IS TABLE OF existing_wip_rsvs%ROWTYPE INDEX BY BINARY_INTEGER;