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.CST_LCMADJUSTMENTS_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 557: INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(

553: li.inventory_item_id,
554: li.prior_landed_cost,
555: li.new_landed_cost,
556: li.transaction_date,
557: INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(
558: li.transaction_date,
559: l_operating_unit),
560: li.organization_id,
561: poh.segment1,

Line 594: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(gps.start_date)

590: AND li.organization_id = p_organization_id
591: AND li.process_status = 2
592: AND gps.application_id = G_PO_APPLICATION_ID
593: AND gps.set_of_books_id = l_ledger_id
594: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(gps.start_date)
595: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(gps.end_date)
596: AND gps.adjustment_period_flag <> 'Y'
597: AND msi.inventory_item_id = li.inventory_item_id
598: AND msi.organization_id = li.organization_id

Line 595: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(gps.end_date)

591: AND li.process_status = 2
592: AND gps.application_id = G_PO_APPLICATION_ID
593: AND gps.set_of_books_id = l_ledger_id
594: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(gps.start_date)
595: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(gps.end_date)
596: AND gps.adjustment_period_flag <> 'Y'
597: AND msi.inventory_item_id = li.inventory_item_id
598: AND msi.organization_id = li.organization_id
599: AND rt.transaction_id = li.rcv_transaction_id

Line 602: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(oap.period_start_date)

598: AND msi.organization_id = li.organization_id
599: AND rt.transaction_id = li.rcv_transaction_id
600: AND poh.po_header_id = rt.po_header_id
601: AND oap.organization_id = li.organization_id
602: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(oap.period_start_date)
603: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(oap.schedule_close_date);
604:
605: IF (l_sLog AND l_pLog) THEN
606: l_num_records := SQL%ROWCOUNT;

Line 603: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(oap.schedule_close_date);

599: AND rt.transaction_id = li.rcv_transaction_id
600: AND poh.po_header_id = rt.po_header_id
601: AND oap.organization_id = li.organization_id
602: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) >= Trunc(oap.period_start_date)
603: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(oap.schedule_close_date);
604:
605: IF (l_sLog AND l_pLog) THEN
606: l_num_records := SQL%ROWCOUNT;
607: FND_LOG.STRING(

Line 2742: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)

2738: mtl_parameters mp,
2739: mtl_system_items_b msi,
2740: rcv_parameters rp
2741: WHERE oap.organization_id (+) = clai.organization_id
2742: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)
2743: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)
2744: AND clai.group_id = p_group_id
2745: AND clai.process_status = 1
2746: AND clai.organization_id = p_organization_id

Line 2743: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)

2739: mtl_system_items_b msi,
2740: rcv_parameters rp
2741: WHERE oap.organization_id (+) = clai.organization_id
2742: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)
2743: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)
2744: AND clai.group_id = p_group_id
2745: AND clai.process_status = 1
2746: AND clai.organization_id = p_organization_id
2747: AND rt.transaction_id (+) = clai.rcv_transaction_id

Line 2757: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)

2753: AND rt.shipment_line_id = rsl.shipment_line_id (+)
2754: AND cai.organization_id (+) = clai.organizatIon_id
2755: AND gps.ledger_id (+) = cai.ledger_id
2756: AND gps.application_id = G_PO_APPLICATION_ID
2757: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2758: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2759: AND gps.adjustment_period_flag <> 'Y'
2760: AND mp.organization_id (+) = clai.organization_id
2761: AND rp.organization_id (+) = clai.organization_id

Line 2758: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)

2754: AND cai.organization_id (+) = clai.organizatIon_id
2755: AND gps.ledger_id (+) = cai.ledger_id
2756: AND gps.application_id = G_PO_APPLICATION_ID
2757: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2758: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2759: AND gps.adjustment_period_flag <> 'Y'
2760: AND mp.organization_id (+) = clai.organization_id
2761: AND rp.organization_id (+) = clai.organization_id
2762: AND msi.inventory_item_id (+) = clai.inventory_item_id

Line 2793: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)

2789: AND clai.organization_id = p_organization_id
2790: AND cai.organization_id = p_organization_id
2791: AND gps.set_of_books_id = cai.ledger_id
2792: AND gps.application_id = G_PO_APPLICATION_ID
2793: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2794: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2795: AND gps.adjustment_period_flag <> 'Y'
2796: and gps.closing_status <> 'O';
2797:

Line 2794: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)

2790: AND cai.organization_id = p_organization_id
2791: AND gps.set_of_books_id = cai.ledger_id
2792: AND gps.application_id = G_PO_APPLICATION_ID
2793: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2794: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2795: AND gps.adjustment_period_flag <> 'Y'
2796: and gps.closing_status <> 'O';
2797:
2798: IF (l_sLog AND l_pLog) THEN