APPS.JAI_AR_TRXS_PKG dependencies on JAI_AR_TRX_INS_HDRS_T

Line 115: From JAI_AR_TRX_INS_HDRS_T

111: Select SHIP_TO_CUSTOMER_ID,SHIP_TO_SITE_USE_ID,CUST_TRX_TYPE_ID,
112: TRX_DATE,SOLD_TO_CUSTOMER_ID,
113: BATCH_SOURCE_ID,
114: BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID
115: From JAI_AR_TRX_INS_HDRS_T
116: Where customer_trx_id = v_customer_trx_id;
117:
118:
119:

Line 172: FROM JAI_AR_TRX_INS_HDRS_T

168: where inventory_item_id = p_inventory_item_id AND
169: ORGANIZATION_ID = P_ORG_ID;
170: cursor organization_cur IS
171: select organization_id,location_id
172: FROM JAI_AR_TRX_INS_HDRS_T
173: WHERE customer_trx_id = v_customer_trx_id;
174: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
175: SELECT MAX(a.fin_year)
176: FROM JAI_CMN_FIN_YEARS a

Line 776: DELETE JAI_AR_TRX_INS_HDRS_T

772:
773: END IF;
774:
775: END LOOP;
776: DELETE JAI_AR_TRX_INS_HDRS_T
777: WHERE CUSTOMER_TRX_ID = v_customer_trx_id;
778:
779: END IF;
780: