APPS.WSMPLBJI dependencies on BOM_OPERATION_SEQUENCES

Line 690: from bom_operation_sequences

686: -- here we are intesrested in the op-seq-num from bos... (abb)
687:
688: select operation_seq_num
689: into l_rtg_op_seq_num
690: from bom_operation_sequences
691: where operation_sequence_id = l_start_seq_id
692: and routing_sequence_id = l_common_routing_sequence_id;
693: -- BD: CZH.I_OED-1
694: --and sysdate <= nvl(disable_date, sysdate+1)

Line 712: from bom_operation_sequences bos, bom_operation_networks bon

708: -- wsmputil.replacement_op_seq_id has been used to find the equivalent effective op-seq-id's. (abb)
709:
710: select unique(bos.operation_sequence_id)
711: into l_bon_seq_id1
712: from bom_operation_sequences bos, bom_operation_networks bon
713: where bos.operation_seq_num = l_rtg_op_seq_num
714: and bos.routing_sequence_id = l_common_routing_sequence_id
715: -- BA: CZH.OED-2, it may have a replacement
716: and (bos.operation_sequence_id = bon.from_op_seq_id

Line 1721: from bom_operation_sequences

1717:
1718: l_stat_num := 10;
1719: select yield, to_char(operation_yield_enabled), department_id
1720: into l_yield, l_operation_yield_enabled,l_department_id
1721: from bom_operation_sequences
1722: where operation_sequence_id = p_seq_id;
1723:
1724: l_stat_num := 30;
1725: select scrap_account, est_absorption_account

Line 1849: FROM BOM_OPERATION_SEQUENCES SEQ

1845: SEQ.ATTRIBUTE14,
1846: SEQ.ATTRIBUTE15,
1847: l_yield,
1848: l_operation_yield_enabled
1849: FROM BOM_OPERATION_SEQUENCES SEQ
1850: WHERE SEQ.ROUTING_SEQUENCE_ID = p_common_routing_sequence_id
1851: AND NVL(SEQ.OPERATION_TYPE, 1) = 1
1852: --BC: CZH.I_OED-1
1853: /****************

Line 1888: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',

1884: into l_seq_incr
1885: from sys.dual;
1886:
1887: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1888: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
1889: X_FROM_PK1_VALUE => to_char(p_seq_id),
1890: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
1891: X_TO_PK1_VALUE => to_char(p_wip_entity_id),
1892: X_TO_PK2_VALUE => to_char(l_seq_incr),

Line 4895: FROM BOM_OPERATION_SEQUENCES BOS

4891: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
4892: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
4893: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4894: AND (BIC.operation_seq_num = (SELECT BOS.operation_seq_num
4895: FROM BOM_OPERATION_SEQUENCES BOS
4896: WHERE operation_sequence_id = l_start_op_seq_id )
4897: OR
4898: BIC.operation_seq_num = 1)
4899: -- BC: BUGFIX 2380517 (CZH.I_OED-2)

Line 5156: FROM BOM_OPERATION_SEQUENCES BOS

5152: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
5153: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
5154: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
5155: AND (BIC.operation_seq_num = (SELECT BOS.operation_seq_num
5156: FROM BOM_OPERATION_SEQUENCES BOS
5157: WHERE operation_sequence_id = l_start_op_seq_id)
5158: OR BIC.operation_seq_num = 1 )
5159: AND NVL(BIC.wip_supply_type, 1) <> 6 -- CHG: BUG 2696937/2652076
5160: