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 2721: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)

2717: mtl_parameters mp,
2718: mtl_system_items_b msi,
2719: rcv_parameters rp
2720: WHERE oap.organization_id (+) = clai.organization_id
2721: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)
2722: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)
2723: AND clai.group_id = p_group_id
2724: AND clai.process_status = 1
2725: AND clai.organization_id = p_organization_id

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

2718: mtl_system_items_b msi,
2719: rcv_parameters rp
2720: WHERE oap.organization_id (+) = clai.organization_id
2721: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)
2722: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)
2723: AND clai.group_id = p_group_id
2724: AND clai.process_status = 1
2725: AND clai.organization_id = p_organization_id
2726: AND rt.transaction_id (+) = clai.rcv_transaction_id

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

2731: AND rae.po_line_id = pol.po_line_id
2732: AND cai.organization_id (+) = clai.organizatIon_id
2733: AND gps.set_of_books_id = rae.set_of_books_id
2734: AND gps.application_id = G_PO_APPLICATION_ID
2735: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2736: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2737: AND gps.adjustment_period_flag <> 'Y'
2738: AND mp.organization_id (+) = clai.organization_id
2739: AND rp.organization_id (+) = clai.organization_id

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

2732: AND cai.organization_id (+) = clai.organizatIon_id
2733: AND gps.set_of_books_id = rae.set_of_books_id
2734: AND gps.application_id = G_PO_APPLICATION_ID
2735: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2736: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2737: AND gps.adjustment_period_flag <> 'Y'
2738: AND mp.organization_id (+) = clai.organization_id
2739: AND rp.organization_id (+) = clai.organization_id
2740: AND msi.inventory_item_id (+) = clai.inventory_item_id

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

2767: AND clai.organization_id = p_organization_id
2768: AND cai.organization_id = p_organization_id
2769: AND gps.set_of_books_id = cai.ledger_id
2770: AND gps.application_id = G_PO_APPLICATION_ID
2771: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2772: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2773: AND gps.adjustment_period_flag <> 'Y'
2774: and gps.closing_status <> 'O';
2775:

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

2768: AND cai.organization_id = p_organization_id
2769: AND gps.set_of_books_id = cai.ledger_id
2770: AND gps.application_id = G_PO_APPLICATION_ID
2771: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(gps.start_date)
2772: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(gps.end_date)
2773: AND gps.adjustment_period_flag <> 'Y'
2774: and gps.closing_status <> 'O';
2775:
2776: IF (l_sLog AND l_pLog) THEN