DBA Data[Home] [Help]

APPS.WSMPVLDT dependencies on MTL_SYSTEM_ITEMS

Line 4735: from mtl_system_items mtl,

4731: UPDATE wsm_resulting_jobs_interface wrji
4732: SET wrji.error_message = l_fnd_generic_err_msg
4733: WHERE wrji.header_id = l_header_id
4734: and not exists (select null
4735: from mtl_system_items mtl,
4736: wsm_split_merge_txn_interface txn
4737: where txn.header_id = wrji.header_id
4738: and txn.transaction_type_id in
4739: (WSMPCNST.SPLIT,

Line 4791: from mtl_system_items mtl,

4787: UPDATE wsm_resulting_jobs_interface wrji
4788: SET wrji.error_message = l_fnd_generic_err_msg
4789: WHERE wrji.header_id = l_header_id
4790: and not exists (select null
4791: from mtl_system_items mtl,
4792: wsm_split_merge_txn_interface txn
4793: where txn.header_id = wrji.header_id
4794: and txn.transaction_type_id in
4795: (WSMPCNST.SPLIT,

Line 4843: from mtl_system_items mtl,

4839: UPDATE wsm_resulting_jobs_interface wrji
4840: SET wrji.error_message = l_fnd_generic_err_msg
4841: WHERE wrji.header_id = l_header_id
4842: and not exists (select null
4843: from mtl_system_items mtl,
4844: wsm_split_merge_txn_interface txn
4845: where txn.header_id = wrji.header_id
4846: and txn.transaction_type_id in
4847: (WSMPCNST.SPLIT,

Line 6425: mtl_system_items msi --bugfix 1828859

6421: UPDATE wsm_resulting_jobs_interface wrji
6422: SET common_bom_sequence_id=
6423: (select bom.common_bill_sequence_id
6424: from bom_bill_of_materials bom,
6425: mtl_system_items msi --bugfix 1828859
6426: where bom.assembly_item_id = wrji.primary_item_id
6427: and bom.alternate_bom_designator is null
6428: and bom.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
6429: and msi.inventory_item_id = bom.assembly_item_id --bugfix 1828859

Line 6474: mtl_system_items msi --bugfix 1828859

6470: AND wrji.rowid = l_wrji_rowid --SpUA add
6471: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6472: AND NOT EXISTS (select 1
6473: from bom_bill_of_materials bom,
6474: mtl_system_items msi --bugfix 1828859
6475: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6476: and bom.alternate_bom_designator = wrji.alternate_bom_designator
6477: and bom.organization_id = l_organization_id
6478: and msi.inventory_item_id = bom.assembly_item_id --bugfix 1828859

Line 6516: mtl_system_items msi --bugfix 1828859

6512: AND wrji.rowid = l_wrji_rowid --SpUA add
6513: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6514: AND NOT EXISTS (select 1
6515: from bom_bill_of_materials bom,
6516: mtl_system_items msi --bugfix 1828859
6517: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6518: --and bom.assembly_item_id=wrji.primary_item_id --bugfix 2077930
6519: and bom.organization_id = l_organization_id -- bugfix 1922146: added orgn_id condn
6520: and msi.inventory_item_id = bom.assembly_item_id --bugfix 1828859

Line 6531: mtl_system_items msi --bugfix 1828859

6527: l_stmt_num := 164;
6528: UPDATE wsm_resulting_jobs_interface wrji
6529: SET wrji.alternate_bom_designator = (select bom.alternate_bom_designator
6530: from bom_bill_of_materials bom,
6531: mtl_system_items msi --bugfix 1828859
6532: where bom.bill_sequence_id = wrji.common_bom_sequence_id
6533: --and bom.assembly_item_id=wrji.primary_item_id --bugfix 2077930
6534: and bom.organization_id = l_organization_id
6535: --bugfix 1922146: added orgn_id condn

Line 6595: mtl_system_items msi --bugfix 1828859

6591: AND wrji.rowid = l_wrji_rowid --SpUA add
6592: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6593: and NOT EXISTS (select 1
6594: from bom_bill_of_materials bom,
6595: mtl_system_items msi --bugfix 1828859
6596: where bom.alternate_bom_designator = wrji.alternate_bom_designator
6597: and bom.assembly_item_id = wrji.primary_item_id
6598: and bom.organization_id = l_organization_id -- bugfix 1922146: added orgn_id condn
6599: and msi.inventory_item_id = bom.assembly_item_id --bugfix 1828859

Line 6610: mtl_system_items msi --bugfix 1828859

6606: l_stmt_num := 166;
6607: UPDATE wsm_resulting_jobs_interface wrji
6608: SET wrji.common_bom_sequence_id = (select bom.common_bill_sequence_id
6609: from bom_bill_of_materials bom,
6610: mtl_system_items msi --bugfix 1828859
6611: where bom.alternate_bom_designator = wrji.alternate_bom_designator
6612: and bom.assembly_item_id = wrji.primary_item_id
6613: and bom.organization_id = l_organization_id
6614: -- bugfix 1922146: added orgn_id condn

Line 6782: mtl_system_items msi --bugfix 1828859

6778: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6779: and not exists
6780: (select null
6781: from bom_bill_alternates_v bba,
6782: mtl_system_items msi --bugfix 1828859
6783: where bba.assembly_item_id = wrji.primary_item_id
6784: and bba.organization_id = wrji.organization_id
6785: and msi.inventory_item_id = bba.assembly_item_id --bugfix 1828859
6786: and msi.organization_id = bba.organization_id

Line 8354: FROM mtl_system_items MS,

8350: MS.restrict_locators_code,
8351: MS.location_control_code item_loc_control
8352: INTO l_sub_loc_control, l_org_loc_control,
8353: l_restrict_locators_code, l_item_loc_control
8354: FROM mtl_system_items MS,
8355: mtl_secondary_inventories MSUB,
8356: mtl_parameters MP
8357: WHERE MP.organization_id = l_organization_id
8358: AND MS.organization_id = l_organization_id