APPS.WMS_XDOCK_PEGGING_PUB dependencies on INV_SALESORDER

Line 2918: l_demand_so_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_header_id);

2914: -- Retrieve necessary parameters for the current demand line from p_wsh_release_table
2915: --l_organization_id := p_wsh_release_table(l_wdd_index).organization_id;
2916: l_inventory_item_id := p_wsh_release_table(l_wdd_index).inventory_item_id;
2917: l_demand_header_id := p_wsh_release_table(l_wdd_index).source_header_id;
2918: l_demand_so_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_header_id);
2919: l_demand_line_id := p_wsh_release_table(l_wdd_index).source_line_id;
2920: l_demand_line_detail_id := p_wsh_release_table(l_wdd_index).delivery_detail_id;
2921: l_demand_qty := p_wsh_release_table(l_wdd_index).requested_quantity;
2922: l_demand_uom_code := p_wsh_release_table(l_wdd_index).requested_quantity_uom;

Line 6410: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,

6406:
6407: -- Cursor to retrieve valid scheduled Sales Order demand lines
6408: CURSOR SO_scheduled_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6409: SELECT
6410: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6411: wdd.source_line_id AS line_id,
6412: wdd.delivery_detail_id AS line_detail_id,
6413: wdd.requested_quantity AS quantity,
6414: wdd.requested_quantity_uom AS uom_code,

Line 6445: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,

6441:
6442: -- Cursor to retrieve valid backordered Sales Order demand lines
6443: CURSOR SO_backordered_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6444: SELECT
6445: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6446: wdd.source_line_id AS line_id,
6447: wdd.delivery_detail_id AS line_detail_id,
6448: wdd.requested_quantity AS quantity,
6449: wdd.requested_quantity_uom AS uom_code,

Line 6480: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,

6476:
6477: -- Cursor to retrieve valid scheduled Internal Order demand lines
6478: CURSOR IO_scheduled_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6479: SELECT
6480: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6481: wdd.source_line_id AS line_id,
6482: wdd.delivery_detail_id AS line_detail_id,
6483: wdd.requested_quantity AS quantity,
6484: wdd.requested_quantity_uom AS uom_code,

Line 6515: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,

6511:
6512: -- Cursor to retrieve valid backordered Internal Order demand lines
6513: CURSOR IO_backordered_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6514: SELECT
6515: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6516: wdd.source_line_id AS line_id,
6517: wdd.delivery_detail_id AS line_detail_id,
6518: wdd.requested_quantity AS quantity,
6519: wdd.requested_quantity_uom AS uom_code,

Line 7613: inv_salesorder.get_oeheader_for_salesorder

7609: l_demand_so_header_id := l_existing_rsvs_tb(l_rsv_index).demand_source_header_id;
7610: l_demand_line_id := l_existing_rsvs_tb(l_rsv_index).demand_source_line_id;
7611:
7612: -- Get the demand OE header ID from the Sales Order header ID
7613: inv_salesorder.get_oeheader_for_salesorder
7614: (p_salesorder_id => l_demand_so_header_id,
7615: x_oe_header_id => l_demand_header_id,
7616: x_return_status => x_return_status);
7617:

Line 9926: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) = p_source_header_id

9922: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9923: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9924: AND ool.line_id = p_source_line_id
9925: AND wdd.source_line_id = ool.line_id
9926: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) = p_source_header_id
9927: AND wdd.delivery_detail_id = wda.delivery_detail_id (+)
9928: AND wda.delivery_id = wnd.delivery_id (+)
9929: AND wnd.delivery_id = wdl.delivery_id (+)
9930: AND (wdl.sequence_number IS NULL OR