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.

[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on INV_RESERVATION_GLOBAL

Line 405: AND supply_source_type_id = inv_reservation_global.g_source_type_wip);

401: AND inventory_item_id = p_inventory_item_id
402: AND demand_source_type_id = p_demand_type_id
403: AND demand_source_header_id = p_demand_header_id
404: AND demand_source_line_id = p_demand_line_id
405: AND supply_source_type_id = inv_reservation_global.g_source_type_wip);
406: EXCEPTION
407: WHEN OTHERS THEN
408: -- This should be when no reservations are found
409: RETURN 'N';

Line 459: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip

455: AND inventory_item_id = p_inventory_item_id
456: AND demand_source_type_id = p_demand_type_id
457: AND demand_source_header_id = p_demand_header_id
458: AND demand_source_line_id = p_demand_line_id
459: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip
460: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv);
461: EXCEPTION
462: WHEN OTHERS THEN
463: -- This should be when no reservations are found

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

456: AND demand_source_type_id = p_demand_type_id
457: AND demand_source_header_id = p_demand_header_id
458: AND demand_source_line_id = p_demand_line_id
459: AND supply_source_type_id <> inv_reservation_global.g_source_type_wip
460: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv);
461: EXCEPTION
462: WHEN OTHERS THEN
463: -- This should be when no reservations are found
464: RETURN 'N';

Line 792: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

788: l_rsv_uom_code2 IN OUT NOCOPY VARCHAR2,
789: l_primary_uom_code IN OUT NOCOPY VARCHAR2,
790: l_conversion_rate IN OUT NOCOPY NUMBER,
791: l_conversion_precision IN NUMBER,
792: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
793: l_rsv_id IN OUT NOCOPY NUMBER,
794: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
795: l_split_wdd_id IN OUT NOCOPY NUMBER,
796: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,

Line 794: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

790: l_conversion_rate IN OUT NOCOPY NUMBER,
791: l_conversion_precision IN NUMBER,
792: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
793: l_rsv_id IN OUT NOCOPY NUMBER,
794: l_to_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
795: l_split_wdd_id IN OUT NOCOPY NUMBER,
796: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,
797: l_demand_expected_time IN OUT NOCOPY DATE,
798: l_supply_expected_time IN OUT NOCOPY DATE,

Line 799: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

795: l_split_wdd_id IN OUT NOCOPY NUMBER,
796: l_crossdock_criteria_id IN OUT NOCOPY NUMBER,
797: l_demand_expected_time IN OUT NOCOPY DATE,
798: l_supply_expected_time IN OUT NOCOPY DATE,
799: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
800: l_split_rsv_id IN OUT NOCOPY NUMBER,
801: l_rsv_qty IN OUT NOCOPY NUMBER,
802: l_rsv_qty2 IN OUT NOCOPY NUMBER,
803: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

Line 803: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

799: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
800: l_split_rsv_id IN OUT NOCOPY NUMBER,
801: l_rsv_qty IN OUT NOCOPY NUMBER,
802: l_rsv_qty2 IN OUT NOCOPY NUMBER,
803: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
804: l_supply_type_id IN OUT NOCOPY NUMBER,
805: x_return_status IN OUT NOCOPY VARCHAR2,
806: x_msg_count IN OUT NOCOPY NUMBER,
807: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 1503: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

1499: l_supply_expected_time IN OUT NOCOPY DATE,
1500: l_demand_expected_time IN OUT NOCOPY DATE,
1501: l_demand_project_id IN OUT NOCOPY NUMBER,
1502: l_demand_task_id IN OUT NOCOPY NUMBER,
1503: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1504: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1505: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1506: l_quantity_reserved IN OUT NOCOPY NUMBER,
1507: l_quantity_reserved2 IN OUT NOCOPY NUMBER,

Line 1504: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

1500: l_demand_expected_time IN OUT NOCOPY DATE,
1501: l_demand_project_id IN OUT NOCOPY NUMBER,
1502: l_demand_task_id IN OUT NOCOPY NUMBER,
1503: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1504: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1505: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1506: l_quantity_reserved IN OUT NOCOPY NUMBER,
1507: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
1508: l_rsv_id IN OUT NOCOPY NUMBER,

Line 1505: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,

1501: l_demand_project_id IN OUT NOCOPY NUMBER,
1502: l_demand_task_id IN OUT NOCOPY NUMBER,
1503: l_original_rsv_rec IN OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
1504: l_original_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1505: l_to_serial_number IN OUT NOCOPY inv_reservation_global.serial_number_tbl_type,
1506: l_quantity_reserved IN OUT NOCOPY NUMBER,
1507: l_quantity_reserved2 IN OUT NOCOPY NUMBER,
1508: l_rsv_id IN OUT NOCOPY NUMBER,
1509: x_return_status IN OUT NOCOPY VARCHAR2,

Line 2119: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv

2115: WHERE organization_id = l_organization_id
2116: AND inventory_item_id = l_inventory_item_id
2117: AND demand_source_type_id = l_demand_type_id
2118: AND demand_source_line_id = l_demand_line_id
2119: AND supply_source_type_id <> inv_reservation_global.g_source_type_inv
2120: AND NVL(crossdock_flag, 'N') = 'N'
2121: AND primary_reservation_quantity - NVL(detailed_quantity, 0) > 0
2122: FOR UPDATE SKIP LOCKED; --Bug 6813492
2123:

Line 2395: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2391: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
2392: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
2393:
2394: -- Variables to split and update reservations records
2395: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2396: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2397: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2398: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2399: l_split_rsv_id NUMBER;

Line 2396: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2392: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
2393:
2394: -- Variables to split and update reservations records
2395: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2396: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2397: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2398: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2399: l_split_rsv_id NUMBER;
2400:

Line 2397: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2393:
2394: -- Variables to split and update reservations records
2395: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2396: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2397: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2398: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2399: l_split_rsv_id NUMBER;
2400:
2401: -- Variables to call the pregenerate API when MOL records are crossdocked

Line 2398: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

2394: -- Variables to split and update reservations records
2395: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2396: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2397: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2398: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2399: l_split_rsv_id NUMBER;
2400:
2401: -- Variables to call the pregenerate API when MOL records are crossdocked
2402: -- to existing reservations.

Line 6550: supply_source_type_id = inv_reservation_global.g_source_type_rcv)

6546: FROM mtl_reservations
6547: WHERE organization_id = l_organization_id
6548: AND inventory_item_id = l_inventory_item_id
6549: AND ((p_lpn_context = 3 AND -- RCV supply
6550: supply_source_type_id = inv_reservation_global.g_source_type_rcv)
6551: OR
6552: (p_lpn_context = 2 AND -- WIP supply
6553: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6554: supply_source_header_id = p_wip_entity_id))

Line 6553: supply_source_type_id = inv_reservation_global.g_source_type_wip AND

6549: AND ((p_lpn_context = 3 AND -- RCV supply
6550: supply_source_type_id = inv_reservation_global.g_source_type_rcv)
6551: OR
6552: (p_lpn_context = 2 AND -- WIP supply
6553: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6554: supply_source_header_id = p_wip_entity_id))
6555: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip
6556: AND demand_source_line_detail IS NULL
6557: AND NVL(crossdock_flag, 'N') = 'N'

Line 6555: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip

6551: OR
6552: (p_lpn_context = 2 AND -- WIP supply
6553: supply_source_type_id = inv_reservation_global.g_source_type_wip AND
6554: supply_source_header_id = p_wip_entity_id))
6555: AND demand_source_type_id <> inv_reservation_global.g_source_type_wip
6556: AND demand_source_line_detail IS NULL
6557: AND NVL(crossdock_flag, 'N') = 'N'
6558: AND primary_reservation_quantity - NVL(detailed_quantity, 0) > 0
6559: FOR UPDATE SKIP LOCKED;

Line 6701: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

6697: l_orig_wdd_values_rec orig_wdd_values_rec;
6698: l_error_code VARCHAR2(3);
6699:
6700: -- Variables to split and update reservations records
6701: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6702: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6703: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6704: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6705: l_split_rsv_id NUMBER;

Line 6702: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

6698: l_error_code VARCHAR2(3);
6699:
6700: -- Variables to split and update reservations records
6701: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6702: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6703: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6704: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6705: l_split_rsv_id NUMBER;
6706:

Line 6703: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

6699:
6700: -- Variables to split and update reservations records
6701: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6702: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6703: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6704: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6705: l_split_rsv_id NUMBER;
6706:
6707: -- Variables to store the available to reserve quantity for a demand or supply line

Line 6704: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

6700: -- Variables to split and update reservations records
6701: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6702: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6703: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
6704: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
6705: l_split_rsv_id NUMBER;
6706:
6707: -- Variables to store the available to reserve quantity for a demand or supply line
6708: -- both in the primary and demand/supply line UOM.

Line 6893: AND supply_source_type_id = inv_reservation_global.g_source_type_wip

6889: SELECT DISTINCT demand_source_type_id, demand_source_header_id, demand_source_line_id
6890: FROM mtl_reservations
6891: WHERE organization_id = l_organization_id
6892: AND inventory_item_id = l_inventory_item_id
6893: AND supply_source_type_id = inv_reservation_global.g_source_type_wip
6894: AND supply_source_header_id = l_supply_header_id;
6895:
6896: -- Table to store the results from the existing WIP reservations cursor
6897: TYPE existing_wip_rsvs_tb IS TABLE OF existing_wip_rsvs%ROWTYPE INDEX BY BINARY_INTEGER;