DBA Data[Home] [Help]

APPS.JA_JAINCINI_XMLP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 214: FROM JAI_CMN_INVENTORY_ORGS

210:
211: FUNCTION M_1FORMATTRIGGER RETURN NUMBER IS
212: CURSOR EC_CODE_CUR IS
213: SELECT INSTR(TR_EC_CODE,'D')
214: FROM JAI_CMN_INVENTORY_ORGS
215: WHERE ORGANIZATION_ID = P_ORG_ID AND LOCATION_ID = P_LOC_ID;
216: V_TR_EC_CODE NUMBER;
217: BEGIN
218: OPEN EC_CODE_CUR;

Line 232: FROM JAI_CMN_INVENTORY_ORGS

228:
229: FUNCTION M_3_GRPFR1FORMATTRIGGER RETURN NUMBER IS
230: CURSOR EC_CODE_CUR IS
231: SELECT INSTR(TR_EC_CODE,'D')
232: FROM JAI_CMN_INVENTORY_ORGS
233: WHERE ORGANIZATION_ID =P_ORG_ID AND LOCATION_ID =P_LOC_ID;
234: V_TR_EC_CODE NUMBER;
235:
236: BEGIN

Line 251: FROM JAI_CMN_INVENTORY_ORGS

247:
248: FUNCTION M_2FORMATTRIGGER RETURN NUMBER IS
249: CURSOR EC_CODE_CUR IS
250: SELECT INSTR(TR_EC_CODE,'D')
251: FROM JAI_CMN_INVENTORY_ORGS
252: WHERE ORGANIZATION_ID =P_ORG_ID AND LOCATION_ID = P_LOC_ID;
253: V_TR_EC_CODE NUMBER;
254:
255: BEGIN