eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PTP_MIGRATE_PKG dependencies on ZX_REGISTRATIONS_S

Line 125: ZX_REGISTRATIONS_S.NEXTVAL, --Registration Id

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

Line 983: ZX_REGISTRATIONS_S.NEXTVAL

979: Last_Update_Date,
980: Last_Update_Login,
981: OBJECT_VERSION_NUMBER)
982: SELECT
983: ZX_REGISTRATIONS_S.NEXTVAL
984: ,Null -- Type
985: ,ptp.rep_registration_number --Registration_Number
986: ,'REGISTERED' -- Registration_Status_code
987: ,'EXPLICIT'

Line 1085: ZX_REGISTRATIONS_S.NEXTVAL

1081: Last_Update_Date,
1082: Last_Update_Login,
1083: Object_Version_Number)
1084: SELECT
1085: ZX_REGISTRATIONS_S.NEXTVAL
1086: ,'CNPJ' -- Type
1087: ,jl.REGISTER_NUMBER||'/'||jl.REGISTER_SUBSIDIARY||'/'||jl.REGISTER_DIGIT Registration_Number
1088: ,'REGISTERED' -- Registration_Status_code
1089: ,'EXPLICIT'

Line 1176: ZX_REGISTRATIONS_S.NEXTVAL

1172: Last_Update_Date,
1173: Last_Update_Login,
1174: Object_Version_Number)
1175: SELECT
1176: ZX_REGISTRATIONS_S.NEXTVAL
1177: ,'STATE INSCRIPTION' -- Type
1178: ,jl.STATE_INSCRIPTION -- Registration_Number
1179: ,'REGISTERED' -- Registration_Status_code
1180: ,'EXPLICIT'

Line 1251: ZX_REGISTRATIONS_S.NEXTVAL

1247: Last_Update_Date,
1248: Last_Update_Login,
1249: OBJECT_VERSION_NUMBER)
1250: SELECT
1251: ZX_REGISTRATIONS_S.NEXTVAL
1252: ,'CITY INSCRIPTION' -- Type
1253: ,jl.MUNICIPAL_INSCRIPTION -- Registration_Number
1254: ,'REGISTERED' -- Registration_Status_code
1255: ,'EXPLICIT'

Line 1463: ZX_REGISTRATIONS_S.NEXTVAL

1459: Last_Update_Date,
1460: Last_Update_Login,
1461: OBJECT_VERSION_NUMBER)
1462: (SELECT
1463: ZX_REGISTRATIONS_S.NEXTVAL
1464: ,Null -- Type
1465: ,decode(pv.GLOBAL_ATTRIBUTE_CATEGORY,
1466: 'JL.AR.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,
1467: 'JL.CL.APXVDMVD.SUPPLIERS',pv.Global_Attribute12||pv.num_1099,

Line 1520: -- ZX_REGISTRATIONS_STATUS lookup type

1516: nvl(l_db_status,'N') in ('I','S')) THEN
1517:
1518: -- Code to migrate the lookup code for the Lookup Type
1519: -- JLZZ_AP_VAT_REG_STAT_CODE into
1520: -- ZX_REGISTRATIONS_STATUS lookup type
1521: insert into fnd_lookup_values(
1522: LOOKUP_TYPE,
1523: LANGUAGE,
1524: LOOKUP_CODE,

Line 1556: 'ZX_REGISTRATIONS_STATUS',

1552: ATTRIBUTE13,
1553: ATTRIBUTE14,
1554: ATTRIBUTE15)
1555: (select
1556: 'ZX_REGISTRATIONS_STATUS',
1557: LANGUAGE,
1558: LOOKUP_CODE,
1559: MEANING,
1560: DESCRIPTION,

Line 1794: ZX_REGISTRATIONS_S.NEXTVAL,

1790: Last_Update_Login,
1791: Object_Version_Number)
1792: values
1793: (
1794: ZX_REGISTRATIONS_S.NEXTVAL,
1795: NULL, --Registration_Type_Code
1796: Registration_Number ,
1797: Registration_Status_Code,
1798: 'EXPLICIT' , -- Registration_Source_Code

Line 1965: ZX_REGISTRATIONS_S.NEXTVAL

1961: Last_Update_Date,
1962: Last_Update_Login,
1963: OBJECT_VERSION_NUMBER)
1964: (SELECT
1965: ZX_REGISTRATIONS_S.NEXTVAL
1966: ,NULL -- Type
1967: ,PVS.VAT_Registration_Num --Reg Number
1968: ,'REGISTERED' -- Registration_Status_code
1969: ,'EXPLICIT' -- Registration_Source_Code

Line 2059: ZX_REGISTRATIONS_S.NEXTVAL

2055: Last_Update_Date,
2056: Last_Update_Login,
2057: Object_Version_Number)
2058: (SELECT
2059: ZX_REGISTRATIONS_S.NEXTVAL
2060: ,'CNPJ' -- Type
2061: ,PVS.Global_Attribute10||' / '||PVS.Global_Attribute11||' / '||PVS.Global_Attribute12 --Reg Number
2062: ,'REGISTERED' -- Registration_Status_code
2063: ,'EXPLICIT'

Line 2133: ZX_REGISTRATIONS_S.NEXTVAL

2129: Last_Update_Date,
2130: Last_Update_Login,
2131: OBJECT_VERSION_NUMBER)
2132: (SELECT
2133: ZX_REGISTRATIONS_S.NEXTVAL
2134: ,'STATE INSCRIPTION' -- Type
2135: ,PVS.Global_Attribute13 -- State Registration Num
2136: ,'REGISTERED' -- Registration_Status_Code
2137: ,'EXPLICIT'

Line 2207: ZX_REGISTRATIONS_S.NEXTVAL

2203: Last_Update_Date,
2204: Last_Update_Login,
2205: OBJECT_VERSION_NUMBER)
2206: (SELECT
2207: ZX_REGISTRATIONS_S.NEXTVAL
2208: ,'CITY INSCRIPTION' -- Type
2209: ,PVS.Global_Attribute14 -- City Registration Num
2210: ,'REGISTERED' -- Registration_Status_Code
2211: ,'EXPLICIT'

Line 3179: -- ZX_REGISTRATIONS_STATUS lookup type

3175: nvl(l_db_status,'N') in ('I','S')) THEN
3176:
3177: -- Code to migrate the lookup code for the Lookup Type
3178: -- JLZZ_AP_VAT_REG_STAT_CODE into
3179: -- ZX_REGISTRATIONS_STATUS lookup type
3180: insert into fnd_lookup_values(
3181: LOOKUP_TYPE,
3182: LANGUAGE,
3183: LOOKUP_CODE,

Line 3215: 'ZX_REGISTRATIONS_STATUS',

3211: ATTRIBUTE13,
3212: ATTRIBUTE14,
3213: ATTRIBUTE15)
3214: (select
3215: 'ZX_REGISTRATIONS_STATUS',
3216: LANGUAGE,
3217: LOOKUP_CODE,
3218: MEANING,
3219: DESCRIPTION,