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 501: FROM OE_INVOICE_TO_ORGS_V

497:
498: /* Find Customer Id of the Header Invoice To Org */
499: SELECT CUSTOMER_ID
500: INTO l_invoice_to_cust_id
501: FROM OE_INVOICE_TO_ORGS_V
502: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id;
503:
504: oe_debug_pub.ADD('Invoice To Customer Id: '||to_char(l_invoice_to_cust_id));
505:

Line 1246: FROM OE_INVOICE_TO_ORGS_V

1242: -- because even for site credit level, we need to pass pay_from_customer
1243: /* Find Customer Id of the Header Invoice To Org */
1244: SELECT CUSTOMER_ID
1245: INTO l_invoice_to_cust_id
1246: FROM OE_INVOICE_TO_ORGS_V
1247: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id;
1248:
1249: oe_debug_pub.ADD('Invoice To Customer Id: '||to_char(l_invoice_to_cust_id));
1250:

Line 1897: FROM oe_invoice_to_orgs_v

1893:
1894: BEGIN
1895: SELECT customer_id
1896: INTO l_customer_id
1897: FROM oe_invoice_to_orgs_v
1898: WHERE ORGANIZATION_ID = p_invoice_to_org_id;
1899: EXCEPTION
1900: WHEN no_data_found then
1901: --x_return_status := FND_API.G_RET_STS_ERROR;