DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2647: FROM hr_all_organization_units

2643: l_update_instance_rec.instance_usage_code := 'OUT_OF_SERVICE';
2644: Begin
2645: SELECT nvl(location_id,NULL)
2646: INTO l_update_instance_rec.location_id
2647: FROM hr_all_organization_units
2648: WHERE organization_id = l_src_instance_header_tbl(i).vld_organization_id;
2649: Exception
2650: WHEN no_data_found THEN
2651: null;

Line 3026: hr_all_organization_units haou,

3022: mtl_system_items_b msib,
3023: mtl_serial_numbers msn,
3024: mtl_unit_transactions mut,
3025: mtl_secondary_inventories msi,
3026: hr_all_organization_units haou,
3027: rcv_transactions rt,
3028: mtl_material_transactions mmt
3029: WHERE
3030: mmt.transaction_id = p_transaction_id AND

Line 3092: hr_all_organization_units haou,

3088: mtl_serial_numbers msn,
3089: mtl_unit_transactions mut,
3090: mtl_transaction_lot_numbers mtln,
3091: mtl_secondary_inventories msi,
3092: hr_all_organization_units haou,
3093: rcv_transactions rt,
3094: mtl_material_transactions mmt
3095: WHERE
3096: mmt.transaction_id = p_transaction_id AND