DBA Data[Home] [Help]

APPS.PO_POXDLPDT_XMLP_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1304: L_LOCATOR MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;

1300: FUNCTION CF_RECEIPT_LOCATIONFORMULA(LOCATOR_ID1 IN NUMBER
1301: ,RECEIPT_LOCATION IN VARCHAR2
1302: ,RECEIVING_SUBINVENTORY IN VARCHAR2) RETURN CHAR IS
1303: L_LOCATION VARCHAR2(300);
1304: L_LOCATOR MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
1305: BEGIN
1306: BEGIN
1307: SELECT
1308: CONCATENATED_SEGMENTS

Line 1311: MTL_ITEM_LOCATIONS_KFV

1307: SELECT
1308: CONCATENATED_SEGMENTS
1309: INTO L_LOCATOR
1310: FROM
1311: MTL_ITEM_LOCATIONS_KFV
1312: WHERE INVENTORY_LOCATION_ID = LOCATOR_ID1;
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: L_LOCATOR := NULL;