[Home] [Help]
1244: AND delete_mark = 0
1245: AND cost_category_id IN
1246: ( SELECT category_id -- cost_category_id Bug#7306720
1247: FROM mtl_item_categories mic,
1248: gmf_process_organizations_gt gpo
1249: WHERE mic.inventory_item_id = p_item_id
1250: AND mic.organization_id = gpo.organization_id
1251: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)
1252: )
6580: WHERE cost_type_id = l_cost_type_id
6581: AND EXISTS (
6582: SELECT 1
6583: FROM gmf_lot_costs glc,
6584: gmf_process_organizations_gt gpo
6585: WHERE glc.organization_id = gpo.organization_id
6586: AND glc.header_id = t.cost_header_id
6587: AND glc.cost_type_id = t.cost_type_id
6588: AND glc.final_cost_flag = 1
7217:
7218: CURSOR get_process_org IS
7219: SELECT organization_code,
7220: organization_id
7221: FROM gmf_process_organizations_gt
7222: ORDER BY organization_code;
7223: l_le_id NUMBER;
7224: procedure_name VARCHAR2(100);
7225: BEGIN
7249: -- B6822310 replace code to load all process orgs.
7250:
7251: Begin
7252: INSERT
7253: INTO GMF_PROCESS_ORGANIZATIONS_GT
7254: (
7255: organization_id,
7256: organization_code,
7257: base_currency_code,
7273: THEN
7274: ll_return_status := -1; --No Rows returned by the API
7275: END IF;
7276:
7277: UPDATE gmf_process_organizations_gt gpo
7278: SET std_uom = (SELECT u.uom_code
7279: FROM mtl_units_of_measure u,
7280: gmd_parameters_hdr h,
7281: gmd_parameters_dtl d
7285: AND d.parameter_name = 'FM_YIELD_TYPE'
7286: AND d.parameter_value = u.uom_class)
7287: WHERE gpo.std_uom IS NULL;
7288:
7289: UPDATE gmf_process_organizations_gt gpo
7290: SET std_uom = (SELECT u.uom_code
7291: FROM mtl_units_of_measure u,
7292: gmd_parameters_hdr h,
7293: gmd_parameters_dtl d
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
7339: AND msi.lot_control_code = 2
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
7368: AND i.lot_control_code = 2
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,
8681: gmf_lot_costed_items_gt lcig
8682: WHERE
8683: gpo.organization_id = mmt.organization_id
8684: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
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
8727: gpo.organization_id = mmt.organization_id
8728: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
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
8772: gpo.organization_id = mmt.owning_organization_id
8773: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
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
8816: gpo.organization_id = mmt.organization_id
8817: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)