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.CZ_PB_MGR dependencies on CZ_XFR_PROJECT_BILLS

Line 9754: FROM cz_xfr_project_bills

9750: IF (v_bom_err_flag = '0')
9751: THEN
9752: SELECT source_server
9753: INTO v_source_server
9754: FROM cz_xfr_project_bills
9755: WHERE model_ps_node_id = (SELECT devl_project_id
9756: FROM cz_ps_nodes
9757: WHERE cz_ps_nodes.ps_node_id = v_bom_ps_node_id AND cz_ps_nodes.deleted_flag = '0');
9758:

Line 17984: ------insert into cz_xfr_project_bills

17980: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17981: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17982: END;
17983:
17984: ------insert into cz_xfr_project_bills
17985: IF (v_rp_orig_sys_ref IS NOT NULL)
17986: THEN
17987: BEGIN
17988: EXECUTE IMMEDIATE 'BEGIN'

Line 17990: || 'insert into cz_xfr_project_bills'

17986: THEN
17987: BEGIN
17988: EXECUTE IMMEDIATE 'BEGIN'
17989: || ' '
17990: || 'insert into cz_xfr_project_bills'
17991: || cz_pb_mgr.v_db_link
17992: || ' ('
17993: || ' '
17994: || 'MODEL_PS_NODE_ID'

Line 18056: || 'FROM cz_xfr_project_bills'

18052: || ',SOURCE_SERVER'
18053: || ' '
18054: || ',COPY_ADDL_CHILD_MODELS'
18055: || ' '
18056: || 'FROM cz_xfr_project_bills'
18057: || ' '
18058: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
18059: || ' '
18060: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

Line 18058: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'

18054: || ',COPY_ADDL_CHILD_MODELS'
18055: || ' '
18056: || 'FROM cz_xfr_project_bills'
18057: || ' '
18058: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
18059: || ' '
18060: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
18061: || ' '
18062: || 'commit;'

Line 18060: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

18056: || 'FROM cz_xfr_project_bills'
18057: || ' '
18058: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
18059: || ' '
18060: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
18061: || ' '
18062: || 'commit;'
18063: || ' '
18064: || 'END;';

Line 19009: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER

19005:
19006: /*
19007: * Bug 5516478
19008: * On migrating a model to a remote server, if there are BOM models involved,
19009: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
19010: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
19011: * migration target. Currently it was being copied from the source to the
19012: * target. In order to do this we need to query CZ_SERVERS in the migration
19013: * target to get the SERVER_LOCAL_ID.

Line 19010: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the

19006: /*
19007: * Bug 5516478
19008: * On migrating a model to a remote server, if there are BOM models involved,
19009: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
19010: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
19011: * migration target. Currently it was being copied from the source to the
19012: * target. In order to do this we need to query CZ_SERVERS in the migration
19013: * target to get the SERVER_LOCAL_ID.
19014: */

Line 19271: ------insert into cz_xfr_project_bills

19267: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
19268: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19269: END;
19270:
19271: ------insert into cz_xfr_project_bills
19272: IF (v_rp_orig_sys_ref IS NOT NULL) THEN
19273: BEGIN
19274: EXECUTE IMMEDIATE 'BEGIN'
19275: || ' '

Line 19276: || 'insert into cz_xfr_project_bills'

19272: IF (v_rp_orig_sys_ref IS NOT NULL) THEN
19273: BEGIN
19274: EXECUTE IMMEDIATE 'BEGIN'
19275: || ' '
19276: || 'insert into cz_xfr_project_bills'
19277: || cz_pb_mgr.v_db_link
19278: || ' ('
19279: || ' '
19280: || 'MODEL_PS_NODE_ID'

Line 19342: || 'FROM cz_xfr_project_bills'

19338: || ',:1'
19339: || ' '
19340: || ',COPY_ADDL_CHILD_MODELS'
19341: || ' '
19342: || 'FROM cz_xfr_project_bills'
19343: || ' '
19344: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19345: || ' '
19346: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

Line 19344: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'

19340: || ',COPY_ADDL_CHILD_MODELS'
19341: || ' '
19342: || 'FROM cz_xfr_project_bills'
19343: || ' '
19344: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19345: || ' '
19346: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
19347: || ' '
19348: || 'commit;'

Line 19346: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'

19342: || 'FROM cz_xfr_project_bills'
19343: || ' '
19344: || 'WHERE cz_xfr_project_bills.MODEL_PS_NODE_ID = cz_pb_mgr.v_imported_ps_node'
19345: || ' '
19346: || 'AND cz_xfr_project_bills.deleted_flag = ''0'';'
19347: || ' '
19348: || 'commit;'
19349: || ' '
19350: || 'END;'

Line 23556: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER

23552: ------------------------------------------------------------------------------------------------
23553: /*
23554: * Bug 5516478
23555: * On migrating a model to a remote server, if there are BOM models involved,
23556: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
23557: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
23558: * migration target. Currently it was being copied from the source to the
23559: * target. In order to do this we need to query CZ_SERVERS in the migration
23560: * target to get the SERVER_LOCAL_ID.

Line 23557: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the

23553: /*
23554: * Bug 5516478
23555: * On migrating a model to a remote server, if there are BOM models involved,
23556: * CZ_XFR_PROJECT_BILLS are also migrated. However, the column SOURCE_SERVER
23557: * in CZ_XFR_PROJECT_BILLS needs to be resolved to the import server on the
23558: * migration target. Currently it was being copied from the source to the
23559: * target. In order to do this we need to query CZ_SERVERS in the migration
23560: * target to get the SERVER_LOCAL_ID.
23561: */