[Home] [Help]
830: gmd.dtl_um,
831: NULL,
832: gmd.cost_alloc
833: )
834: FROM mtl_system_items_b iimb,
835: mtl_material_transactions mmt,
836: gme_batch_step_items gbsi,
837: gme_material_details gmd,
838: mtl_transaction_lot_numbers mtln,
895: gmd.dtl_um,
896: NULL ,
897: gmd.cost_alloc
898: )
899: FROM mtl_system_items_b iimb,
900: mtl_material_transactions mmt,
901: gme_material_details gmd,
902: mtl_transaction_lot_numbers mtln,
903: mtl_parameters mp,
941: gmd.dtl_um,
942: NULL ,
943: gmd.cost_alloc
944: )
945: FROM mtl_system_items_b iimb,
946: mtl_material_transactions mmt,
947: gme_material_details gmd,
948: mtl_transaction_lot_numbers mtln,
949: hr_organization_information hoi
984: gme.dtl_um,
985: NULL ,
986: gme.cost_alloc
987: )
988: FROM mtl_system_items_b iimb,
989: mtl_material_transactions mmt,
990: gme_material_details gme,
991: mtl_transaction_lot_numbers mtln,
992: gme_transaction_pairs gtp
7330: msi.organization_id,
7331: msi.inventory_item_id,
7332: msi.primary_uom_code
7333: FROM gmf_lot_costed_items lci,
7334: mtl_system_items_b msi,
7335: gmf_process_organizations_gt gpo
7336: WHERE lci.legal_entity_id = p_le_id
7337: AND lci.delete_mark = 0 /* ANTHIYAG Bug#5279681 06-Jun-2006 */
7338: AND gpo.organization_id = msi.organization_id
7359: mic.inventory_item_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
7360: i.primary_uom_code
7361: FROM mtl_item_categories mic,
7362: gmf_lot_costed_items g,
7363: mtl_system_items_b i,
7364: gmf_process_organizations_gt gpo
7365: WHERE g.cost_category_id = mic.category_id
7366: AND g.legal_entity_id = l_le_id
7367: AND g.delete_mark = 0
8851: 0 as transfer_transaction_id,
8852: 0 as transaction_cost,
8853: 0 as transfer_transaction_id
8854: FROM gmf_lot_cost_adjustments glca,
8855: mtl_system_items_b iimb,
8856: gmf_lot_costed_items_gt glci
8857: WHERE glca.applied_ind = 'N'
8858: AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date)
8859: AND glca.legal_entity_id = l_le_id