APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_INVOICE_TO_ORGS_V

Line 1201: From oe_invoice_to_orgs_v

1197: --bug 4729536
1198: CURSOR cur_customer_relations IS
1199:
1200: Select /*MOAC_SQL_NO_CHANGE*/ 'VALID' a
1201: From oe_invoice_to_orgs_v
1202: WHERE site_use_id = p_line_rec.invoice_to_org_id
1203: AND status = 'A'
1204: AND customer_id = p_line_rec.sold_to_org_id
1205: and rownum =1

Line 1210: FROM oe_invoice_to_orgs_v oito

1206:
1207: UNION ALL
1208:
1209: SELECT /*MOAC_SQL_NO_CHANGE*/ 'VALID' a
1210: FROM oe_invoice_to_orgs_v oito
1211: WHERE oito.site_use_id = p_line_rec.invoice_to_org_id
1212: AND oito.status = 'A' AND
1213: EXISTS
1214: (

Line 2098: From oe_invoice_to_orgs_v

2094: IF nvl(lcustomer_relations,'N') = 'N' THEN
2095:
2096: Select 'VALID'
2097: Into l_dummy
2098: From oe_invoice_to_orgs_v
2099: Where customer_id = p_line_rec.sold_to_org_id
2100: And site_use_id = p_line_rec.invoice_to_org_id;
2101:
2102: ELSIF lcustomer_relations = 'Y' THEN

Line 2106: From oe_invoice_to_orgs_v

2102: ELSIF lcustomer_relations = 'Y' THEN
2103:
2104: /*Select MOAC_SQL_NO_CHANGE 'VALID'
2105: Into l_dummy
2106: From oe_invoice_to_orgs_v
2107: WHERE site_use_id = p_line_rec.invoice_to_org_id
2108: AND status = 'A' AND
2109: customer_id in (
2110: Select p_line_rec.sold_to_org_id from dual

Line 2135: From oe_invoice_to_orgs_v

2131: ('Cr: A',2);
2132:
2133: SELECT 'VALID'
2134: INTO l_dummy
2135: From oe_invoice_to_orgs_v
2136: WHERE site_use_id = p_line_rec.invoice_to_org_id
2137: AND ROWNUM = 1;
2138:
2139: