APPS.CTO_ATP_INTERFACE_PK dependencies on STANDARD

Line 12: ** 4) eliminate mandatory components and stand alone standard items

8: **
9: ** 1) Get ship set
10: ** 2) get additional info from OEOL, MSYI, BIC
11: ** 3) return ship set if no models or config items( atp may be doing this )
12: ** 4) eliminate mandatory components and stand alone standard items
13: ** 5) arrange data for sparse array traversal
14: ** 6) populate level
15: ** 7) populate parent ato
16: ** 8) unscramble array

Line 1077: ** 4) Filter out mandatory components(permanent) and standard/ATO items( temporary ) for model processing.

1073: ** Processing Steps
1074: ** 1) evaluate source of call ( CZ or OM ) and type of action ( enquiry, schedule, reschedule, cancel, delete )
1075: ** 2) Retrieve relevant information required for processing according to the request
1076: ** 3) Return if no models found in the shipset
1077: ** 4) Filter out mandatory components(permanent) and standard/ATO items( temporary ) for model processing.
1078: ** 5) Populate plan level
1079: ** 6) Populate Parent ATO
1080: ** 7) Unscramble the data and reorder it
1081: ** 8) Evaluate sourcing for the entire shipset

Line 1298: ** copy original shipset tracker excluding mandatory and stand alone standard items

1294: return ;
1295: END IF ;
1296:
1297: /*
1298: ** copy original shipset tracker excluding mandatory and stand alone standard items
1299: ** into v_raw_shipset_tracker.
1300: ** position tracker contents by lineid location for sparse index traversal
1301: */
1302: l_stmt_num := 260 ;

Line 1756: /* remove standard items and ato items */

1752:
1753: ELSIF( local_cto_shipset(i).top_model_line_id is null AND
1754: local_cto_shipset(i).bom_item_type = 4 )
1755: THEN
1756: /* remove standard items and ato items */
1757:
1758: IF PG_DEBUG <> 0 THEN
1759: oe_debug_pub.add('evaluate_shipset: ' || 'Filtering PTO, removing standard item for line_id::' || local_cto_shipset(i).line_id , 2 );
1760: END IF;

Line 1759: oe_debug_pub.add('evaluate_shipset: ' || 'Filtering PTO, removing standard item for line_id::' || local_cto_shipset(i).line_id , 2 );

1755: THEN
1756: /* remove standard items and ato items */
1757:
1758: IF PG_DEBUG <> 0 THEN
1759: oe_debug_pub.add('evaluate_shipset: ' || 'Filtering PTO, removing standard item for line_id::' || local_cto_shipset(i).line_id , 2 );
1760: END IF;
1761:
1762: local_cto_shipset.delete(i) ;
1763:

Line 4020: /* this code will be executed for standard items part of shipset */

4016: END IF ; /* if g_cto_sparse_shipset is a sourced shipset */
4017:
4018: ELSE
4019: /* shipset line does not exist */
4020: /* this code will be executed for standard items part of shipset */
4021: /* Changes to support product substitution */
4022:
4023: IF PG_DEBUG <> 0 THEN
4024: oe_debug_pub.add('resurrect_shipset: ' || ' shipset line does not exist ' || p_shipset.identifier(i) , 5);

Line 6561: AND ( oeol.item_type_code = 'STANDARD' OR oeol.item_type_code = 'OPTION' )

6557: oeol.open_flag = 'Y' /* SRS added for performance to retrieve only open orde
6558: rs */
6559: AND oeol.ship_from_org_id is not null
6560: AND nvl(oeol.visible_demand_flag,'N') = 'Y'
6561: AND ( oeol.item_type_code = 'STANDARD' OR oeol.item_type_code = 'OPTION' )
6562: /* added item_code = 'OPTION' to support ATO ITEMs under PTO Models per
6563: BUG#1874380 */
6564: AND oeol.line_id = oeol.ato_line_id
6565: AND nvl(oeol.source_document_type_id,0) <> 10; -- This is confirmed with OM