[Home] [Help]
121: PROGRAM_LOGIN_ID,
122: OBJECT_VERSION_NUMBER)
123: SELECT
124:
125: ZX_REGISTRATIONS_S.NEXTVAL, --Registration Id
126: NULL, --Registration_Type_Code
127: p_reg_info , --Registration Number
128: 'REGISTERED', --Registration Status Code
129: 'EXPLICIT', --Registration Source Code
859: Last_Update_Date,
860: Last_Update_Login,
861: OBJECT_VERSION_NUMBER)
862: SELECT
863: ZX_REGISTRATIONS_S.NEXTVAL
864: ,Null -- Type
865: ,ptp.rep_registration_number --Registration_Number
866: ,'REGISTERED' -- Registration_Status_code
867: ,'EXPLICIT'
961: Last_Update_Date,
962: Last_Update_Login,
963: Object_Version_Number)
964: SELECT
965: ZX_REGISTRATIONS_S.NEXTVAL
966: ,'CNPJ' -- Type
967: ,jl.REGISTER_NUMBER||'/'||jl.REGISTER_SUBSIDIARY||'/'||jl.REGISTER_DIGIT Registration_Number
968: ,'REGISTERED' -- Registration_Status_code
969: ,'EXPLICIT'
1052: Last_Update_Date,
1053: Last_Update_Login,
1054: Object_Version_Number)
1055: SELECT
1056: ZX_REGISTRATIONS_S.NEXTVAL
1057: ,'STATE INSCRIPTION' -- Type
1058: ,jl.STATE_INSCRIPTION -- Registration_Number
1059: ,'REGISTERED' -- Registration_Status_code
1060: ,'EXPLICIT'
1127: Last_Update_Date,
1128: Last_Update_Login,
1129: OBJECT_VERSION_NUMBER)
1130: SELECT
1131: ZX_REGISTRATIONS_S.NEXTVAL
1132: ,'CITY INSCRIPTION' -- Type
1133: ,jl.MUNICIPAL_INSCRIPTION -- Registration_Number
1134: ,'REGISTERED' -- Registration_Status_code
1135: ,'EXPLICIT'
1339: Last_Update_Date,
1340: Last_Update_Login,
1341: OBJECT_VERSION_NUMBER)
1342: (SELECT
1343: ZX_REGISTRATIONS_S.NEXTVAL
1344: ,Null -- Type
1345: ,decode(pv.GLOBAL_ATTRIBUTE_CATEGORY,
1346: 'JL.AR.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,
1347: 'JL.CL.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,
1396: nvl(l_db_status,'N') in ('I','S')) THEN
1397:
1398: -- Code to migrate the lookup code for the Lookup Type
1399: -- JLZZ_AP_VAT_REG_STAT_CODE into
1400: -- ZX_REGISTRATIONS_STATUS lookup type
1401: insert into fnd_lookup_values(
1402: LOOKUP_TYPE,
1403: LANGUAGE,
1404: LOOKUP_CODE,
1432: ATTRIBUTE13,
1433: ATTRIBUTE14,
1434: ATTRIBUTE15)
1435: (select
1436: 'ZX_REGISTRATIONS_STATUS',
1437: LANGUAGE,
1438: LOOKUP_CODE,
1439: MEANING,
1440: DESCRIPTION,
1670: Last_Update_Login,
1671: Object_Version_Number)
1672: values
1673: (
1674: ZX_REGISTRATIONS_S.NEXTVAL,
1675: NULL, --Registration_Type_Code
1676: Registration_Number ,
1677: Registration_Status_Code,
1678: 'EXPLICIT' , -- Registration_Source_Code
1841: Last_Update_Date,
1842: Last_Update_Login,
1843: OBJECT_VERSION_NUMBER)
1844: (SELECT
1845: ZX_REGISTRATIONS_S.NEXTVAL
1846: ,NULL -- Type
1847: ,PVS.VAT_Registration_Num --Reg Number
1848: ,'REGISTERED' -- Registration_Status_code
1849: ,'EXPLICIT' -- Registration_Source_Code
1935: Last_Update_Date,
1936: Last_Update_Login,
1937: Object_Version_Number)
1938: (SELECT
1939: ZX_REGISTRATIONS_S.NEXTVAL
1940: ,'CNPJ' -- Type
1941: ,PVS.Global_Attribute10||' / '||PVS.Global_Attribute11||' / '||PVS.Global_Attribute12 --Reg Number
1942: ,'REGISTERED' -- Registration_Status_code
1943: ,'EXPLICIT'
2009: Last_Update_Date,
2010: Last_Update_Login,
2011: OBJECT_VERSION_NUMBER)
2012: (SELECT
2013: ZX_REGISTRATIONS_S.NEXTVAL
2014: ,'STATE INSCRIPTION' -- Type
2015: ,PVS.Global_Attribute13 -- State Registration Num
2016: ,'REGISTERED' -- Registration_Status_Code
2017: ,'EXPLICIT'
2083: Last_Update_Date,
2084: Last_Update_Login,
2085: OBJECT_VERSION_NUMBER)
2086: (SELECT
2087: ZX_REGISTRATIONS_S.NEXTVAL
2088: ,'CITY INSCRIPTION' -- Type
2089: ,PVS.Global_Attribute14 -- City Registration Num
2090: ,'REGISTERED' -- Registration_Status_Code
2091: ,'EXPLICIT'
3055: nvl(l_db_status,'N') in ('I','S')) THEN
3056:
3057: -- Code to migrate the lookup code for the Lookup Type
3058: -- JLZZ_AP_VAT_REG_STAT_CODE into
3059: -- ZX_REGISTRATIONS_STATUS lookup type
3060: insert into fnd_lookup_values(
3061: LOOKUP_TYPE,
3062: LANGUAGE,
3063: LOOKUP_CODE,
3091: ATTRIBUTE13,
3092: ATTRIBUTE14,
3093: ATTRIBUTE15)
3094: (select
3095: 'ZX_REGISTRATIONS_STATUS',
3096: LANGUAGE,
3097: LOOKUP_CODE,
3098: MEANING,
3099: DESCRIPTION,