1056: END IF;
1057: */
1058:
1059: /* Serial Effectivity Implementation */
1060: IF (bom_eamutil.enabled = 'Y'
1061: AND bom_eamutil.serial_effective_item (item_id => from_item_id,
1062: org_id => x_from_org_id
1063: ) = 'Y'
1064: )
1057: */
1058:
1059: /* Serial Effectivity Implementation */
1060: IF (bom_eamutil.enabled = 'Y'
1061: AND bom_eamutil.serial_effective_item (item_id => from_item_id,
1062: org_id => x_from_org_id
1063: ) = 'Y'
1064: )
1065: OR (pjm_unit_eff.enabled = 'Y'
4983: BEGIN
4984: sql_stmt_num := 40;
4985:
4986: /* Serial Effectivity Implementation */
4987: IF (bom_eamutil.enabled = 'Y'
4988: AND bom_eamutil.serial_effective_item (item_id => to_item_id,
4989: org_id => to_org_id
4990: ) = 'Y'
4991: )
4984: sql_stmt_num := 40;
4985:
4986: /* Serial Effectivity Implementation */
4987: IF (bom_eamutil.enabled = 'Y'
4988: AND bom_eamutil.serial_effective_item (item_id => to_item_id,
4989: org_id => to_org_id
4990: ) = 'Y'
4991: )
4992: OR (pjm_unit_eff.enabled = 'Y'
7408:
7409: l_to_eff_ctrl := p_trgt_str_eff_ctrl;
7410:
7411: /* Serial Effectivity Implementation */
7412: IF (bom_eamutil.enabled = 'Y'
7413: AND bom_eamutil.serial_effective_item (item_id => from_item_id,
7414: org_id => x_from_org_id
7415: ) = 'Y'
7416: )
7409: l_to_eff_ctrl := p_trgt_str_eff_ctrl;
7410:
7411: /* Serial Effectivity Implementation */
7412: IF (bom_eamutil.enabled = 'Y'
7413: AND bom_eamutil.serial_effective_item (item_id => from_item_id,
7414: org_id => x_from_org_id
7415: ) = 'Y'
7416: )
7417: OR (pjm_unit_eff.enabled = 'Y'
10618: BEGIN
10619: sql_stmt_num := 40;
10620:
10621: /* Serial Effectivity Implementation */
10622: IF (bom_eamutil.enabled = 'Y'
10623: AND bom_eamutil.serial_effective_item (item_id => to_item_id,
10624: org_id => to_org_id
10625: ) = 'Y'
10626: )
10619: sql_stmt_num := 40;
10620:
10621: /* Serial Effectivity Implementation */
10622: IF (bom_eamutil.enabled = 'Y'
10623: AND bom_eamutil.serial_effective_item (item_id => to_item_id,
10624: org_id => to_org_id
10625: ) = 'Y'
10626: )
10627: OR (pjm_unit_eff.enabled = 'Y'