APPS.WMS_XDOCK_PEGGING_PUB dependencies on INV_SALESORDER

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

2860: -- Retrieve necessary parameters for the current demand line from p_wsh_release_table
2861: --l_organization_id := p_wsh_release_table(l_wdd_index).organization_id;
2862: l_inventory_item_id := p_wsh_release_table(l_wdd_index).inventory_item_id;
2863: l_demand_header_id := p_wsh_release_table(l_wdd_index).source_header_id;
2864: l_demand_so_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_header_id);
2865: l_demand_line_id := p_wsh_release_table(l_wdd_index).source_line_id;
2866: l_demand_line_detail_id := p_wsh_release_table(l_wdd_index).delivery_detail_id;
2867: l_demand_qty := p_wsh_release_table(l_wdd_index).requested_quantity;
2868: l_demand_uom_code := p_wsh_release_table(l_wdd_index).requested_quantity_uom;

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

6235:
6236: -- Cursor to retrieve valid scheduled Sales Order demand lines
6237: CURSOR SO_scheduled_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6238: SELECT
6239: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6240: wdd.source_line_id AS line_id,
6241: wdd.delivery_detail_id AS line_detail_id,
6242: wdd.requested_quantity AS quantity,
6243: wdd.requested_quantity_uom AS uom_code,

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

6269:
6270: -- Cursor to retrieve valid backordered Sales Order demand lines
6271: CURSOR SO_backordered_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6272: SELECT
6273: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6274: wdd.source_line_id AS line_id,
6275: wdd.delivery_detail_id AS line_detail_id,
6276: wdd.requested_quantity AS quantity,
6277: wdd.requested_quantity_uom AS uom_code,

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

6303:
6304: -- Cursor to retrieve valid scheduled Internal Order demand lines
6305: CURSOR IO_scheduled_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6306: SELECT
6307: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6308: wdd.source_line_id AS line_id,
6309: wdd.delivery_detail_id AS line_detail_id,
6310: wdd.requested_quantity AS quantity,
6311: wdd.requested_quantity_uom AS uom_code,

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

6337:
6338: -- Cursor to retrieve valid backordered Internal Order demand lines
6339: CURSOR IO_backordered_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6340: SELECT
6341: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) AS header_id,
6342: wdd.source_line_id AS line_id,
6343: wdd.delivery_detail_id AS line_detail_id,
6344: wdd.requested_quantity AS quantity,
6345: wdd.requested_quantity_uom AS uom_code,

Line 7438: inv_salesorder.get_oeheader_for_salesorder

7434: l_demand_so_header_id := l_existing_rsvs_tb(l_rsv_index).demand_source_header_id;
7435: l_demand_line_id := l_existing_rsvs_tb(l_rsv_index).demand_source_line_id;
7436:
7437: -- Get the demand OE header ID from the Sales Order header ID
7438: inv_salesorder.get_oeheader_for_salesorder
7439: (p_salesorder_id => l_demand_so_header_id,
7440: x_oe_header_id => l_demand_header_id,
7441: x_return_status => x_return_status);
7442:

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

9727: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9728: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9729: AND ool.line_id = p_source_line_id
9730: AND wdd.source_line_id = ool.line_id
9731: AND inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id) = p_source_header_id
9732: AND wdd.delivery_detail_id = wda.delivery_detail_id (+)
9733: AND wda.delivery_id = wnd.delivery_id (+)
9734: AND wnd.delivery_id = wdl.delivery_id (+)
9735: AND (wdl.sequence_number IS NULL OR