APPS.OE_CREDIT_PUB dependencies on OE_INVOICE_TO_ORGS_V

Line 44: FROM OE_INVOICE_TO_ORGS_V

40: select 'Any Past due invoice'
41: into l_dummy
42: from AR_PAYMENT_SCHEDULES
43: WHERE CUSTOMER_ID = ( SELECT CUSTOMER_ID
44: FROM OE_INVOICE_TO_ORGS_V
45: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id)
46: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
47: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
48: AND AMOUNT_DUE_REMAINING > 0

Line 517: FROM OE_INVOICE_TO_ORGS_V

513:
514: /* Find Customer Id of the Header Invoice To Org */
515: SELECT CUSTOMER_ID
516: INTO l_invoice_to_cust_id
517: FROM OE_INVOICE_TO_ORGS_V
518: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id;
519:
520: oe_debug_pub.ADD('Invoice To Customer Id: '||to_char(l_invoice_to_cust_id));
521:

Line 1264: FROM OE_INVOICE_TO_ORGS_V

1260: -- because even for site credit level, we need to pass pay_from_customer
1261: /* Find Customer Id of the Header Invoice To Org */
1262: SELECT CUSTOMER_ID
1263: INTO l_invoice_to_cust_id
1264: FROM OE_INVOICE_TO_ORGS_V
1265: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id;
1266:
1267: oe_debug_pub.ADD('Invoice To Customer Id: '||to_char(l_invoice_to_cust_id));
1268:

Line 1915: FROM oe_invoice_to_orgs_v

1911:
1912: BEGIN
1913: SELECT customer_id
1914: INTO l_customer_id
1915: FROM oe_invoice_to_orgs_v
1916: WHERE ORGANIZATION_ID = p_invoice_to_org_id;
1917: EXCEPTION
1918: WHEN no_data_found then
1919: --x_return_status := FND_API.G_RET_STS_ERROR;