DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS_B

Line 91: mtl_system_items_b msi

87: -1 * mti.transaction_quantity txnQty, --make qty relative to wip (relative to inv in table)
88: msi.lot_control_code lotControlCode,
89: msi.serial_number_control_code serialNumControlCode
90: from mtl_transactions_interface mti,
91: mtl_system_items_b msi
92: where mti.transaction_header_id = p_txnHdrID
93: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
94: wip_constants.issnegc_action, wip_constants.retnegc_action)
95: and mti.operation_seq_num between p_firstOp and p_lastOp

Line 1125: from bom_parameters bp, mtl_system_items_b msi

1121: into l_inheritPhOpSeq,
1122: l_grpID,
1123: l_bomItemType,
1124: l_maxBomLevel
1125: from bom_parameters bp, mtl_system_items_b msi
1126: where bp.organization_id = p_orgID
1127: and bp.organization_id = msi.organization_id
1128: and msi.inventory_item_id = p_itemID;
1129: exception