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.CSTPSCCR dependencies on FND_DATE

Line 763: l_rev_datetime := fnd_date.canonical_to_date(revision_date);

759: /* Bug 3098303: initialize l_rev_datetime, revision_date has all time components */
760: /* Bug 3590153: use local variables l_rev_datetime and l_phantom_mat to improve performance */
761: sql_stmt_num := 1;
762:
763: l_rev_datetime := fnd_date.canonical_to_date(revision_date);
764:
765: sql_stmt_num := 2;
766:
767: l_phantom_mat := nvl(fnd_profile.value('CST_RU_PHANTOM_MATERIAL'),1);

Line 1061: fnd_date.canonical_to_date( revision_date )

1057: and bos2.operation_seq_num = bos.operation_seq_num
1058:
1059: /* Fix for BUG 1607662 */
1060: and bos2.EFFECTIVITY_DATE <=
1061: fnd_date.canonical_to_date( revision_date )
1062: )
1063: )
1064: )
1065:

Line 1219: AND bos2.effectivity_date <= fnd_date.canonical_to_date(revision_date)

1215: AND NVL( bos2.operation_type, 1 ) = NVL( bos.operation_type, 1 )
1216: AND bos2.operation_seq_num = bos.operation_seq_num
1217:
1218: /* Fix for BUG 1607662 */
1219: AND bos2.effectivity_date <= fnd_date.canonical_to_date(revision_date)
1220: )
1221: )
1222: )
1223: AND NVL( bos.eco_for_production, 2 ) = 2

Line 1555: fnd_date.canonical_to_date( revision_date )

1551: and bos2.operation_seq_num = bos.operation_seq_num
1552:
1553: /* Fix for BUG 1607662 */
1554: and bos2.EFFECTIVITY_DATE <=
1555: fnd_date.canonical_to_date( revision_date )
1556: )
1557: )
1558: )
1559:

Line 2282: AND bos2.EFFECTIVITY_DATE <= fnd_date.canonical_to_date( revision_date )

2278: AND NVL(bos2.operation_type, 1) = NVL(bos.operation_type, 1)
2279: AND bos2.operation_seq_num = bos.operation_seq_num
2280:
2281: /* Fix for BUG 1607662 */
2282: AND bos2.EFFECTIVITY_DATE <= fnd_date.canonical_to_date( revision_date )
2283: )
2284: )
2285: )
2286:

Line 2833: l_rollup_date DATE := fnd_date.canonical_to_date(rollup_date);

2829: invalid_rows_found EXCEPTION;
2830: CONC_STATUS BOOLEAN;
2831: esa_flag NUMBER;
2832: l_login_id number := -1;
2833: l_rollup_date DATE := fnd_date.canonical_to_date(rollup_date);
2834: dummy number;
2835:
2836: TYPE inv_item_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2837: TYPE dep_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2884: and fnd_date.canonical_to_date(rollup_date) >= bos.effectivity_date

2880:
2881: and bor.organization_id = l_organization_id
2882: /* Bug 2379908. Use common_routing_sequence_id */
2883: and bos.routing_sequence_id = bor.common_routing_sequence_id
2884: and fnd_date.canonical_to_date(rollup_date) >= bos.effectivity_date
2885:
2886: and NVL( bos.disable_date,
2887: fnd_date.canonical_to_date(rollup_date) + 1 )
2888: >= fnd_date.canonical_to_date(rollup_date)

Line 2887: fnd_date.canonical_to_date(rollup_date) + 1 )

2883: and bos.routing_sequence_id = bor.common_routing_sequence_id
2884: and fnd_date.canonical_to_date(rollup_date) >= bos.effectivity_date
2885:
2886: and NVL( bos.disable_date,
2887: fnd_date.canonical_to_date(rollup_date) + 1 )
2888: >= fnd_date.canonical_to_date(rollup_date)
2889:
2890: /* Right now, ECO does not support Op Yield */
2891: AND bos.implementation_date is not null

Line 2888: >= fnd_date.canonical_to_date(rollup_date)

2884: and fnd_date.canonical_to_date(rollup_date) >= bos.effectivity_date
2885:
2886: and NVL( bos.disable_date,
2887: fnd_date.canonical_to_date(rollup_date) + 1 )
2888: >= fnd_date.canonical_to_date(rollup_date)
2889:
2890: /* Right now, ECO does not support Op Yield */
2891: AND bos.implementation_date is not null
2892: AND NVL( bos.include_in_rollup, 1 ) = 1

Line 3135: p_canonical_rev_date CONSTANT DATE := fnd_date.canonical_to_date(revision_date);

3131: l_snapshot_designator VARCHAR2(40);
3132: alt_org NUMBER:=0;
3133: p_rollup_date CONSTANT DATE := TO_DATE(l_rollup_date,'YYYY/MM/DD HH24:MI:SS');
3134: p_revision_date CONSTANT DATE := TO_DATE(revision_date,'YYYY/MM/DD HH24:MI:SS');
3135: p_canonical_rev_date CONSTANT DATE := fnd_date.canonical_to_date(revision_date);
3136: l_req_id NUMBER;
3137: l_prg_appl_id NUMBER;
3138: l_prg_id NUMBER;
3139: l_prg_update_date DATE;

Line 3536: AND bic.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)

3532:
3533: AND bbom2.ASSEMBLY_ITEM_ID = cia.INVENTORY_ITEM_ID
3534: AND bbom2.ORGANIZATION_ID = csllc.organization_id
3535: AND bbom2.ALTERNATE_BOM_DESIGNATOR = l_snapshot_designator
3536: AND bic.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)
3537: AND NVL(bic.DISABLE_DATE,fnd_date.canonical_to_date(revision_date)+1)> fnd_date.canonical_to_date(revision_date)
3538: AND(((l_unimp_flag = 2)AND(bic.IMPLEMENTATION_DATE IS NOT NULL))
3539: OR((l_unimp_flag = 1)
3540: AND bic.EFFECTIVITY_DATE = (

Line 3537: AND NVL(bic.DISABLE_DATE,fnd_date.canonical_to_date(revision_date)+1)> fnd_date.canonical_to_date(revision_date)

3533: AND bbom2.ASSEMBLY_ITEM_ID = cia.INVENTORY_ITEM_ID
3534: AND bbom2.ORGANIZATION_ID = csllc.organization_id
3535: AND bbom2.ALTERNATE_BOM_DESIGNATOR = l_snapshot_designator
3536: AND bic.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)
3537: AND NVL(bic.DISABLE_DATE,fnd_date.canonical_to_date(revision_date)+1)> fnd_date.canonical_to_date(revision_date)
3538: AND(((l_unimp_flag = 2)AND(bic.IMPLEMENTATION_DATE IS NOT NULL))
3539: OR((l_unimp_flag = 1)
3540: AND bic.EFFECTIVITY_DATE = (
3541: SELECT MAX(bic1.EFFECTIVITY_DATE)

Line 3548: AND bic1.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)

3544: OR(decode(bic1.IMPLEMENTATION_DATE, NULL,bic1.OLD_COMPONENT_SEQUENCE_ID,bic1.COMPONENT_SEQUENCE_ID) =decode(bic.IMPLEMENTATION_DATE, NULL,bic.OLD_COMPONENT_SEQUENCE_ID,bic.COMPONENT_SEQUENCE_ID))
3545: )
3546: AND bic1.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID
3547: AND bic1.COMPONENT_ITEM_ID = bic.COMPONENT_ITEM_ID
3548: AND bic1.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)
3549: AND NVL( bic1.eco_for_production, 2 ) = 2
3550: )
3551: )
3552: )