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 1060: fnd_date.canonical_to_date( revision_date )

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

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

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

Line 1558: fnd_date.canonical_to_date( revision_date )

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

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

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

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

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

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

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

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

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

Line 2889: >= fnd_date.canonical_to_date(rollup_date)

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

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

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

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

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

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

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

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

3545: 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))
3546: )
3547: AND bic1.BILL_SEQUENCE_ID = bic.BILL_SEQUENCE_ID
3548: AND bic1.COMPONENT_ITEM_ID = bic.COMPONENT_ITEM_ID
3549: AND bic1.EFFECTIVITY_DATE <=fnd_date.canonical_to_date(revision_date)
3550: AND NVL( bic1.eco_for_production, 2 ) = 2
3551: )
3552: )
3553: )