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.WIP_WICTPG dependencies on WIP_DISCRETE_JOBS

Line 296: AND ENTITY_NAME = 'WIP_DISCRETE_JOBS'

292: into x_num_rows
293: from FND_ATTACHED_DOCUMENTS
294: WHERE PK1_VALUE = to_char(x_purge_rec.wip_entity_id)
295: AND (( PK2_VALUE = to_char(x_purge_rec.org_id)
296: AND ENTITY_NAME = 'WIP_DISCRETE_JOBS'
297: )
298: OR ( PK3_VALUE = to_char(x_purge_rec.org_id)
299: AND ENTITY_NAME = 'WIP_DISCRETE_OPERATIONS'
300: )

Line 324: X_entity_name => 'WIP_DISCRETE_JOBS',

320: X_delete_document_flag => 'Y' );
321: end if;
322:
323: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
324: X_entity_name => 'WIP_DISCRETE_JOBS',
325: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
326: X_pk2_value => to_char(x_purge_rec.org_id),
327: X_delete_document_flag => 'Y' );
328: end if ;

Line 764: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

760: FROM WIP_TRANSACTIONS WT
761: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
762: AND WT.TRANSACTION_TYPE IN (11,12)
763: AND NOT EXISTS (SELECT 1 FROM
764: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
765: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
766: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
767: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
768: UNION

Line 774: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

770: FROM WIP_TRANSACTION_ACCOUNTS WT
771: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
772: AND NOT EXISTS
773: ( SELECT 1 FROM
774: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
775: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
776: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
777: AND NVL(WDJ.DATE_CLOSED,SYSDATE) > p_cut_off_date)
778: );

Line 796: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

792: FROM WIP_TRANSACTIONS WT
793: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
794: AND WT.TRANSACTION_TYPE IN (11,12)
795: AND NOT EXISTS (SELECT 1 FROM
796: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
797: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
798: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
799: AND NVL(WDJ.DATE_CLOSED,SYSDATE) >= p_cut_off_date)
800: UNION

Line 806: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ

802: FROM WIP_TRANSACTION_ACCOUNTS WT
803: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
804: AND NOT EXISTS
805: ( SELECT 1 FROM
806: WIP_TRANSACTION_ACCOUNTS WTA1, WIP_DISCRETE_JOBS WDJ
807: WHERE WTA1.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
808: AND WTA1.TRANSACTION_ID=WT.TRANSACTION_ID
809: AND NVL(WDJ.DATE_CLOSED,SYSDATE) > p_cut_off_date)
810: );

Line 1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);

1100:
1101:
1102: -- check for foreign key references
1103: fnd_message.set_name('WIP', 'WIP_PURGE_FOREIGN_KEY');
1104: fnd_message.set_token('TABLE', 'WIP_DISCRETE_JOBS', TRUE);
1105: x_purge_rec.info := fnd_message.get;
1106:
1107: x_purge_rec.table_name := 'CST_STD_COST_ADJ_VALUES';
1108:

Line 1920: x_purge_rec.table_name := 'WIP_DISCRETE_JOBS';

1916: num_rows => x_num_rows);
1917: end if;
1918:
1919:
1920: x_purge_rec.table_name := 'WIP_DISCRETE_JOBS';
1921:
1922: if (p_option = REPORT_ONLY) then
1923: SELECT COUNT(*) INTO x_num_rows
1924: FROM WIP_DISCRETE_JOBS

Line 1924: FROM WIP_DISCRETE_JOBS

1920: x_purge_rec.table_name := 'WIP_DISCRETE_JOBS';
1921:
1922: if (p_option = REPORT_ONLY) then
1923: SELECT COUNT(*) INTO x_num_rows
1924: FROM WIP_DISCRETE_JOBS
1925: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1926: else
1927: DELETE FROM WIP_DISCRETE_JOBS
1928: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1927: DELETE FROM WIP_DISCRETE_JOBS

1923: SELECT COUNT(*) INTO x_num_rows
1924: FROM WIP_DISCRETE_JOBS
1925: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1926: else
1927: DELETE FROM WIP_DISCRETE_JOBS
1928: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1929: x_num_rows := SQL%ROWCOUNT ;
1930: end if ;
1931:

Line 2325: ' from wip_discrete_jobs wdj, ' ||

2321: ' wdj.scheduled_completion_date, ' ||
2322: ' wdj.date_closed, ' ||
2323: ' wdj.status_type, ' ||
2324: ' wdj.organization_id ' ||
2325: ' from wip_discrete_jobs wdj, ' ||
2326: ' wip_entities we ' ||
2327: /* Fix for bug#4902938 - Convert Literal to Bind variable*/
2328: ' where we.organization_id = :l_organization_id' ||
2329: ' and we.organization_id = wdj.organization_id ' ||