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

Line 1463: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1459: -- WorkOrder_Rec number;
1460:
1461: /* Reservation Variables */
1462: l_rec_reserve CTO_RESERVE_CONFIG.rec_reserve;
1463: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1464: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1465: l_rsrv_qty number := 0;
1466: l_rsrv_id number;
1467: l_status varchar2(1);

Line 1464: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1460:
1461: /* Reservation Variables */
1462: l_rec_reserve CTO_RESERVE_CONFIG.rec_reserve;
1463: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1464: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1465: l_rsrv_qty number := 0;
1466: l_rsrv_id number;
1467: l_status varchar2(1);
1468: l_activity_status varchar2(8);

Line 1516: inv_reservation_global.g_source_type_wip,

1512: msi.primary_uom_code,
1513: oel.order_quantity_uom,
1514: null,
1515: null) start_quantity,
1516: inv_reservation_global.g_source_type_wip,
1517: wei.wip_entity_id,
1518: oel.schedule_ship_date,
1519: -- Passing revision info only if revision_qty_control_code
1520: -- is not equal to 1

Line 1633: l_rec_reserve.f_supply_source := inv_reservation_global.g_source_type_wip;

1629: l_rec_reserve.f_item_id := WorkOrder_Rec.inventory_item_id;
1630: l_rec_reserve.f_order_qty_uom := WorkOrder_Rec.order_quantity_uom;
1631: --l_rec_reserve.f_quantity := WorkOrder_Rec.ordered_quantity;
1632: l_rec_reserve.f_quantity := WorkOrder_Rec.start_quantity;
1633: l_rec_reserve.f_supply_source := inv_reservation_global.g_source_type_wip;
1634: l_rec_reserve.f_supply_header_id := WorkOrder_Rec.wip_entity_id;
1635: l_rec_reserve.f_ship_date := WorkOrder_Rec.schedule_ship_date;
1636: l_rec_reserve.f_source_document_type_id := WorkOrder_Rec.source_document_type_id; -- bugfix 1799874
1637: l_rec_reserve.f_bom_revision := WorkOrder_Rec.bom_revision; -- 2620282 : Passing bom revision info

Line 1911: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,

1907: and mr.organization_id = oel.ship_from_org_id
1908: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
1909: and oel.ship_from_org_id = msi.organization_id
1910: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
1911: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1912: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874
1913:
1914:
1915: -- Cursor to get qty in wip_job_schedule_interface

Line 1912: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874

1908: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
1909: and oel.ship_from_org_id = msi.organization_id
1910: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
1911: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1912: INV_RESERVATION_GLOBAL.g_source_type_oe); --bugfix 1799874
1913:
1914:
1915: -- Cursor to get qty in wip_job_schedule_interface
1916: -- This cursor was modified for bugs 2074290, 2435875, 2455900

Line 1937: and demand_source_type = inv_reservation_global.g_source_type_oe;

1933: cursor flow_supply is
1934: select nvl(sum(planned_quantity - quantity_completed),0) -- 2946071
1935: from wip_flow_schedules
1936: where demand_source_line = to_char(pLineId)
1937: and demand_source_type = inv_reservation_global.g_source_type_oe;
1938:
1939: /* end bugfix 2868148 */
1940:
1941: l_mtl_rsv_qty number := 0;