APPS.WSMPOPRN dependencies on BOM_OPERATION_SEQUENCES

Line 308: FROM BOM_OPERATION_SEQUENCES bos,

304:
305: l_stat_num := 240;
306: SELECT count(*)
307: INTO l_count
308: FROM BOM_OPERATION_SEQUENCES bos,
309: WIP_DISCRETE_JOBS wdj
310: WHERE wdj.WIP_ENTITY_ID = X_Wip_Entity_Id
311: AND wdj.ORGANIZATION_ID = X_Organization_Id
312: -- AND bos.standard_operation_id = X_Standard_Operation_Id

Line 476: BOM_OPERATION_SEQUENCES SEQ,

472: DJ.QUANTITY_SCRAPPED,
473: 0,
474: SEQ.LOWEST_ACCEPTABLE_YIELD
475: FROM BOM_OPERATIONAL_ROUTINGS R,
476: BOM_OPERATION_SEQUENCES SEQ,
477: WIP_DISCRETE_JOBS DJ
478: WHERE SEQ.ROUTING_SEQUENCE_ID =
479: nvl(r.common_routing_sequence_id, r.routing_sequence_id)
480: -- BC: CZH.I_OED-1, should honor routing revision date

Line 509: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',

505: and operation_seq_num = x_to_op
506: and organization_id = x_organization_id;
507:
508: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
509: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
510: X_FROM_PK1_VALUE => to_char(l_op_seq_id),
511: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
512: X_TO_PK1_VALUE => to_char(x_wip_entity_id),
513: X_TO_PK2_VALUE => to_char(x_to_op),

Line 1417: -- BOM_OPERATION_SEQUENCES BOS, fix bug 1611094

1413: WO.CREATED_BY, WO.LAST_UPDATE_LOGIN, WO.REQUEST_ID,
1414: WO.PROGRAM_APPLICATION_ID, WO.PROGRAM_ID, WO.PROGRAM_UPDATE_DATE,
1415: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
1416: FROM WIP_OPERATIONS WO,
1417: -- BOM_OPERATION_SEQUENCES BOS, fix bug 1611094
1418: BOM_DEPARTMENTS BD
1419: WHERE WO.WIP_ENTITY_ID = X_Wip_Entity_Id
1420: AND WO.OPERATION_SEQ_NUM = X_op_seq_num
1421: AND WO.ORGANIZATION_ID = X_Organization_Id

Line 1804: BOM_OPERATION_SEQUENCES BOS

1800: INVENTORY_LOCATION_ID
1801: INTO l_secondary_inventory_name,
1802: l_secondary_locator
1803: FROM WSM_OPERATION_DETAILS WOD,
1804: BOM_OPERATION_SEQUENCES BOS
1805: WHERE WOD.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
1806: AND BOS.OPERATION_SEQUENCE_ID = l_end_op_seq_id;
1807: */
1808: SELECT DEFAULT_SUBINVENTORY,

Line 1813: BOM_OPERATION_SEQUENCES BOS

1809: DEFAULT_LOCATOR_ID
1810: INTO l_secondary_inventory_name,
1811: l_secondary_locator
1812: FROM BOM_STANDARD_OPERATIONS BSO,
1813: BOM_OPERATION_SEQUENCES BOS
1814: WHERE BSO.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID
1815: AND BOS.OPERATION_SEQUENCE_ID = l_end_op_seq_id;
1816:
1817: EXCEPTION

Line 2373: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',

2369: --bugfix 2026218
2370: --copy attachment from operations document attachment defined in the network routing form.
2371: IF SQL%ROWCOUNT > 0 THEN
2372: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
2373: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
2374: X_FROM_PK1_VALUE => to_char(p_to_op_seq_id),
2375: X_TO_ENTITY_NAME => 'WSM_LOT_BASED_OPERATIONS',
2376: X_TO_PK1_VALUE => to_char(p_wip_entity_id),
2377: X_TO_PK2_VALUE => to_char(p_to_job_op_seq_num),