DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on HZ_CUST_ACCOUNTS

Line 1216: HZ_CUST_ACCOUNTS CUST_ACCT

1212: WF_ITEM_ACTIVITY_STATUSES WF,
1213: WF_PROCESS_ACTIVITIES WPA,
1214: --RA_CUSTOMERS OEC /*TCA Cleanup */
1215: HZ_PARTIES PARTY,
1216: HZ_CUST_ACCOUNTS CUST_ACCT
1217: WHERE
1218: OEL.LINE_CATEGORY_CODE='RETURN'
1219: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id
1220: AND OEL.HEADER_ID = OEH.HEADER_ID

Line 1994: HZ_CUST_ACCOUNTS CUST_ACCT

1990: --WF_ITEM_ACTIVITY_STATUSES WF,
1991: --WF_PROCESS_ACTIVITIES WPA,
1992: --RA_CUSTOMERS OEC
1993: HZ_PARTIES PARTY,
1994: HZ_CUST_ACCOUNTS CUST_ACCT
1995: WHERE flv.lookup_code = 'RMA'
1996: AND flv.lookup_type = 'DOC_TYPE'
1997: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1998: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2621: HZ_CUST_ACCOUNTS CUST_ACCT

2617: --WF_ITEM_ACTIVITY_STATUSES WF,
2618: --WF_PROCESS_ACTIVITIES WPA,
2619: --RA_CUSTOMERS OEC /*TCA Cleanup */
2620: HZ_PARTIES PARTY,
2621: HZ_CUST_ACCOUNTS CUST_ACCT
2622: WHERE flv.lookup_code = 'RMA'
2623: AND flv.lookup_type = 'DOC_TYPE'
2624: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2625: AND nvl(flv.end_date_active,sysdate) >= SYSDATE