[Home] [Help]
581: oap.acct_period_id,
582: msi.inventory_asset_flag
583: FROM cst_lc_adj_interface li,
584: gl_period_statuses gps,
585: mtl_system_items_b msi,
586: po_headers_all poh,
587: org_acct_periods oap,
588: rcv_transactions rt
589: WHERE li.group_id = p_group_id
1558: FROM cst_lc_adj_acctg_info_gt acc,
1559: cst_lc_rcv_txn_gt rt,
1560: mtl_secondary_inventories mse,
1561: mtl_material_transactions mmt,
1562: mtl_system_items_b msi
1563: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1564: or (rt.transaction_type = 'CORRECT'
1565: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))
1566: and rt.lcm_transaction_id = acc.lcm_transaction_id
1718: and mse.organization_id = acc.organization_id
1719: and mmt.rcv_transaction_id = rt.rcv_transaction_id
1720: and mmt.transaction_id = mclacd.transaction_id
1721: AND (acc.inventory_asset_flag = 'Y' AND Nvl(mse.asset_inventory,2) = 1)) txn,
1722: mtl_system_items_b msi
1723: WHERE msi.inventory_item_id = txn.inventory_item_id
1724: AND msi.organization_id= txn.organization_id
1725: GROUP BY txn.lcm_transaction_id, txn.COST_GROUP_ID,
1726: txn.INV_LAYER_ID,
2735: po_distributions_all pod,
2736: gl_period_statuses gps,
2737: cst_acct_info_v cai,
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)