APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_INVOICE_TO_ORGS_V

Line 1200: From oe_invoice_to_orgs_v

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

Line 1209: FROM oe_invoice_to_orgs_v oito

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

Line 2097: From oe_invoice_to_orgs_v

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

Line 2105: From oe_invoice_to_orgs_v

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

Line 2134: From oe_invoice_to_orgs_v

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