APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_INVOICE_TO_ORGS_V

Line 877: FROM OE_INVOICE_TO_ORGS_V

873: l_id NUMBER;
874:
875: CURSOR c_invoice_to_org_id IS
876: SELECT ORGANIZATION_ID
877: FROM OE_INVOICE_TO_ORGS_V
878: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
879: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
880: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
881: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 919: FROM OE_INVOICE_TO_ORGS_V

915: return l_id;
916: ELSE
917: SELECT ORGANIZATION_ID
918: INTO l_id
919: FROM OE_INVOICE_TO_ORGS_V
920: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
921: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
922: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
923: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 996: FROM OE_INVOICE_TO_ORGS_V

992: lcustomer_relations varchar2(1);
993:
994: CURSOR c_invoice_to_org_id IS
995: SELECT ORGANIZATION_ID
996: FROM OE_INVOICE_TO_ORGS_V
997: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
998: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
999: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1000: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1017: FROM OE_INVOICE_TO_ORGS_V

1013: AND CUSTOMER_ID = p_sold_to_org_id;
1014:
1015: CURSOR C1 IS
1016: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1017: FROM OE_INVOICE_TO_ORGS_V
1018: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1019: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1020: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1021: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1044: FROM OE_INVOICE_TO_ORGS_V

1040: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
1041: and bill_to_flag = 'Y');
1042: CURSOR C2 IS
1043: SELECT ORGANIZATION_ID
1044: FROM OE_INVOICE_TO_ORGS_V
1045: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1046: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1047: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1048: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1092: FROM OE_INVOICE_TO_ORGS_V

1088: return l_id;
1089: ELSE
1090: SELECT ORGANIZATION_ID
1091: INTO l_id
1092: FROM OE_INVOICE_TO_ORGS_V
1093: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1094: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1095: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1096: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1122: FROM OE_INVOICE_TO_ORGS_V

1118: return l_id;
1119: ELSE
1120: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1121: INTO l_id
1122: FROM OE_INVOICE_TO_ORGS_V
1123: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1124: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1125: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1126: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1160: FROM OE_INVOICE_TO_ORGS_V

1156: return l_id;
1157: ELSE
1158: SELECT ORGANIZATION_ID
1159: INTO l_id
1160: FROM OE_INVOICE_TO_ORGS_V
1161: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1162: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1163: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1164: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =