APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on WIP_PARAMETERS

Line 1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;

1632:
1633: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;

Line 1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;

1633: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1641:

Line 1955: Default Supply Subinventory from WIP Parameters.

1951: END IF ; /*end if p_receive_quantity > l_quantity_ordered - l_quantity_delivered*/
1952:
1953: /*
1954: If there is no subinventory associated with PO Distributions then get
1955: Default Supply Subinventory from WIP Parameters.
1956: */
1957: IF l_dest_subinventory IS NULL
1958: THEN
1959: -- find the default subinventory

Line 1973: FROM wip_parameters wip_para

1969:
1970: BEGIN
1971: SELECT wip_para.default_pull_supply_subinv
1972: INTO l_dest_subinventory
1973: FROM wip_parameters wip_para
1974: WHERE wip_para.Organization_Id = p_inventory_org_id;
1975: EXCEPTION
1976: WHEN no_data_found THEN
1977: JMF_SHIKYU_UTIL.debug_output

Line 2024: FROM wip_parameters wip_para

2020: --get the DEFAULT_PULL_SUPPLY_LOCATOR_ID
2021: BEGIN
2022: SELECT wip_para.default_pull_supply_locator_id
2023: INTO l_default_locator_id
2024: FROM wip_parameters wip_para
2025: WHERE wip_para.Organization_Id = p_inventory_org_id;
2026: EXCEPTION
2027: WHEN no_data_found THEN
2028: JMF_SHIKYU_UTIL.debug_output