DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on HZ_CUST_ACCOUNTS

Line 1248: HZ_CUST_ACCOUNTS CUST_ACCT

1244: WF_ITEM_ACTIVITY_STATUSES WF,
1245: WF_PROCESS_ACTIVITIES WPA,
1246: --RA_CUSTOMERS OEC /*TCA Cleanup */
1247: HZ_PARTIES PARTY,
1248: HZ_CUST_ACCOUNTS CUST_ACCT
1249: WHERE
1250: OEL.LINE_CATEGORY_CODE='RETURN'
1251: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
1252: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 2036: HZ_CUST_ACCOUNTS CUST_ACCT

2032: --WF_ITEM_ACTIVITY_STATUSES WF,
2033: --WF_PROCESS_ACTIVITIES WPA,
2034: --RA_CUSTOMERS OEC
2035: HZ_PARTIES PARTY,
2036: HZ_CUST_ACCOUNTS CUST_ACCT
2037: WHERE flv.lookup_code = 'RMA'
2038: AND flv.lookup_type = 'DOC_TYPE'
2039: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2040: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2675: HZ_CUST_ACCOUNTS CUST_ACCT

2671: --WF_ITEM_ACTIVITY_STATUSES WF,
2672: --WF_PROCESS_ACTIVITIES WPA,
2673: --RA_CUSTOMERS OEC /*TCA Cleanup */
2674: HZ_PARTIES PARTY,
2675: HZ_CUST_ACCOUNTS CUST_ACCT
2676: WHERE flv.lookup_code = 'RMA'
2677: AND flv.lookup_type = 'DOC_TYPE'
2678: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2679: AND nvl(flv.end_date_active,sysdate) >= SYSDATE