DBA Data[Home] [Help]

APPS.JA_JAINVAR_XMLP_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 17: RA_CUSTOMER_TRX_LINES_ALL

13: CURSOR GET_PICKING_LINE_ID_CUR IS
14: SELECT
15: INTERFACE_LINE_ATTRIBUTE7
16: FROM
17: RA_CUSTOMER_TRX_LINES_ALL
18: WHERE CUSTOMER_TRX_ID = CF_1FORMULA.CUSTOMER_TRX_ID
19: AND CUSTOMER_TRX_LINE_ID = CF_1FORMULA.CUSTOMER_TRX_LINE_ID
20: AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;
21: CURSOR GET_ITEM_ID_CUR(V_PICKING_LINE_ID IN NUMBER) IS

Line 432: RA_CUSTOMER_TRX_LINES_ALL

428: CURSOR GET_PICKING_LINE_ID_CUR IS
429: SELECT
430: INTERFACE_LINE_ATTRIBUTE7
431: FROM
432: RA_CUSTOMER_TRX_LINES_ALL
433: WHERE CUSTOMER_TRX_ID = CF_17FORMULA.CUSTOMER_TRX_ID
434: AND CUSTOMER_TRX_LINE_ID = CF_17FORMULA.CUSTOMER_TRX_LINE_ID
435: AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;
436: CURSOR GET_ITEM_ID_CUR(V_PICKING_LINE_ID IN NUMBER) IS

Line 517: RA_CUSTOMER_TRX_LINES_ALL

513: CURSOR GET_PICKING_LINE_ID_CUR IS
514: SELECT
515: INTERFACE_LINE_ATTRIBUTE7
516: FROM
517: RA_CUSTOMER_TRX_LINES_ALL
518: WHERE CUSTOMER_TRX_ID = CF_20FORMULA.CUSTOMER_TRX_ID
519: AND CUSTOMER_TRX_LINE_ID = CF_20FORMULA.CUSTOMER_TRX_LINE_ID
520: AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;
521: CURSOR GET_SELLING_PRICE_CUR(V_PICKING_LINE_ID IN NUMBER) IS

Line 645: RA_CUSTOMER_TRX_LINES_ALL

641: CURSOR GET_PICKING_LINE_ID_CUR IS
642: SELECT
643: INTERFACE_LINE_ATTRIBUTE7
644: FROM
645: RA_CUSTOMER_TRX_LINES_ALL
646: WHERE CUSTOMER_TRX_ID = CONV_ASSESSABLEFORMULA.CUSTOMER_TRX_ID
647: AND CUSTOMER_TRX_LINE_ID = CONV_ASSESSABLEFORMULA.CUSTOMER_TRX_LINE_ID
648: AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;
649: CURSOR GET_ASSESSABLE_VALUE_CUR(V_PICKING_LINE_ID IN NUMBER) IS

Line 819: RA_CUSTOMER_TRX_LINES_ALL

815: CURSOR GET_PICKING_LINE_ID_CUR IS
816: SELECT
817: INTERFACE_LINE_ATTRIBUTE7
818: FROM
819: RA_CUSTOMER_TRX_LINES_ALL
820: WHERE CUSTOMER_TRX_ID = ITEM_CODE_IDFORMULA.CUSTOMER_TRX_ID
821: AND CUSTOMER_TRX_LINE_ID = ITEM_CODE_IDFORMULA.CUSTOMER_TRX_LINE_ID
822: AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;
823: CURSOR GET_INVENTORY_ITEM_ID(V_PICKING_LINE_ID IN NUMBER) IS