[Home] [Help]
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,
839: mtl_parameters mp,
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,
904: hr_organization_information hoi
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
950: WHERE mmt.transaction_source_type_id = 5
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
993: WHERE mmt.trx_source_line_id = gme.material_detail_id
2217: FROM rcv_transactions t,
2218: po_rcv_charges rc,
2219: po_rcv_charge_allocations rca,
2220: mtl_units_of_measure uom,
2221: mtl_material_transactions mmt /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2222: WHERE mmt.transaction_id = transaction_row.transaction_id /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2223: AND t.transaction_id = mmt.rcv_transaction_id
2224: AND t.shipment_header_id = rc.shipment_header_id
2225: AND t.shipment_line_id = rca.shipment_line_id
3022:
3023: CURSOR get_src_qty_uom IS
3024: select mtln.primary_quantity,
3025: lcig.primary_uom_code
3026: from mtl_material_transactions mmt,
3027: mtl_transaction_lot_numbers mtln,
3028: gmf_lot_costed_items_gt lcig
3029: where mmt.transaction_id = transaction_row.transfer_transaction_id
3030: AND mmt.transaction_id = mtln.transaction_id
3538: receipt_qty,
3539: receipt_uom,
3540: document_code,
3541: l_exchange_rate
3542: FROM rcv_transactions t, mtl_units_of_measure u, mtl_material_transactions mmt -- jboppana
3543: , po_distributions_all pda
3544: WHERE t.source_doc_unit_of_measure = u.unit_of_measure(+)
3545: AND t.transaction_id = mmt.rcv_transaction_id
3546: -- AND mmt.transaction_source_id = transaction_row.doc_id
3593: INTO
3594: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
3595: FROM
3596: rcv_transactions t,
3597: mtl_material_transactions mmt,
3598: rcv_shipment_headers r,
3599: rcv_shipment_lines rsl,
3600: po_headers_all poh,
3601: hr_organization_information hoi1,
3633: INTO
3634: target_orgn_id,source_orgn_id, source_le_id, target_le_id, l_shipped_date
3635: FROM
3636: rcv_transactions t,
3637: mtl_material_transactions mmt,
3638: rcv_shipment_headers r,
3639: rcv_shipment_lines rsl,
3640: po_headers_all poh,
3641: hr_organization_information hoi1,
5052:
5053:
5054: SELECT COUNT (DISTINCT mmt.inventory_item_id)
5055: INTO l_unassociated_prds
5056: FROM mtl_material_transactions mmt, gme_material_details gmd
5057: WHERE mmt.transaction_source_type_id = 5
5058: AND mmt.transaction_source_id = gmd.batch_id
5059: AND gmd.line_type = 1
5060: AND mmt.transaction_quantity <> 0
7434: --check if there is cost from parent lot At this point
7435: SELECT mln.lot_number
7436: INTO l_parent_lot_number
7437: FROM mtl_transaction_lot_numbers mln,
7438: mtl_material_transactions mmt
7439: WHERE mmt.transaction_id = transaction_row.transfer_transaction_id
7440: AND mmt.transaction_id = mln.transaction_id;
7441:
7442: OPEN lot_cost_cursor(transaction_row.orgn_id,
7573: CURSOR child_lots_cursor IS
7574: SELECT mtln.lot_number,
7575: ABS(mtln.primary_quantity),
7576: mtln.transaction_date
7577: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
7578: WHERE mmt.transfer_transaction_id = transaction_row.transfer_transaction_id
7579: AND mmt.transaction_id <> transaction_row.transfer_transaction_id
7580: AND mmt.transaction_id = mtln.transaction_id ;
7581:
8232: -- logical intransit receipt.
8233:
8234: SELECT transaction_id
8235: INTO l_trans_id
8236: FROM mtl_material_transactions
8237: WHERE transfer_transaction_id = transaction_row.transfer_transaction_id
8238: AND transaction_action_id = 15;
8239:
8240: SELECT cost_header_id
8672: mmt.fob_point,
8673: mmt.transfer_transaction_id,
8674: NVL(mmt.transaction_cost,0),
8675: mmt.transfer_organization_id
8676: FROM mtl_material_transactions mmt,
8677: gme_material_details gme,
8678: mtl_transaction_lot_numbers mtln,
8679: gme_transaction_pairs gtp,
8680: gmf_process_organizations_gt gpo,
8718: mmt.fob_point,
8719: mmt.transfer_transaction_id,
8720: NVL(mmt.transaction_cost,0),
8721: mmt.transfer_organization_id
8722: FROM mtl_material_transactions mmt,
8723: mtl_transaction_lot_numbers mtln,
8724: gmf_process_organizations_gt gpo,
8725: gmf_lot_costed_items_gt lcig
8726: WHERE
8763: mmt.fob_point,
8764: mmt.transfer_transaction_id,
8765: NVL(mmt.transaction_cost,0),
8766: mmt.transfer_organization_id
8767: FROM mtl_material_transactions mmt,
8768: mtl_transaction_lot_numbers mtln,
8769: gmf_process_organizations_gt gpo,
8770: gmf_lot_costed_items_gt lcig
8771: WHERE
8807: mmt.fob_point,
8808: mmt.transfer_transaction_id,
8809: NVL(mmt.transaction_cost,0),
8810: mmt.transfer_organization_id
8811: FROM mtl_material_transactions mmt,
8812: mtl_transaction_lot_numbers mtln,
8813: gmf_process_organizations_gt gpo,
8814: gmf_lot_costed_items_gt lcig
8815: WHERE
9156: SELECT transfer_organization_id,
9157: hoi.org_information2
9158: INTO l_source_orgn_id,
9159: l_source_le_id
9160: FROM mtl_material_transactions mmt,
9161: hr_organization_information hoi
9162: WHERE mmt.transaction_id = transaction_row.transaction_id
9163: AND hoi.organization_id = mmt.transfer_organization_id
9164: AND hoi.org_information_context = 'Accounting Information';