eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_INTERFACE_PRICING_ATTRIBS

Line 223: FROM qp_interface_pricing_attribs pa

219: pricing_attr_value_from,
220: pricing_attr_value_from_disp,
221: pricing_attr_value_to,
222: pricing_attr_value_to_disp
223: FROM qp_interface_pricing_attribs pa
224: WHERE pa.request_id = p_request_id
225: AND pa.process_status_flag = 'P'
226: AND pa.interface_action_code IN ('INSERT','UPDATE');
227:

Line 294: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa

290: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
291:
292: -- 3.Product Attribute
293: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute');
294: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
295: SET (PRODUCT_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
296: (SELECT a.segment_mapping_column,
297: DECODE(a.segment_mapping_column, NULL, null, 'P'),
298: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'003',qipa.ATTRIBUTE_STATUS)

Line 299: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

295: SET (PRODUCT_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
296: (SELECT a.segment_mapping_column,
297: DECODE(a.segment_mapping_column, NULL, null, 'P'),
298: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'003',qipa.ATTRIBUTE_STATUS)
299: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
300: WHERE b.prc_context_id = a.prc_context_id
301: AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
302: AND a.segment_code = c.PRODUCT_ATTR_CODE
303: AND a.segment_mapping_column like 'PRICING%'

Line 319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

315: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Precedence');
316: UPDATE QP_INTERFACE_LIST_LINES qill
317: SET PRODUCT_PRECEDENCE=
318: (SELECT NVL(a.USER_PRECEDENCE, a.SEEDED_PRECEDENCE)
319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
320: WHERE b.prc_context_id = a.prc_context_id
321: AND b.prc_context_code = c.PRODUCT_ATTRIBUTE_CONTEXT
322: AND a.segment_code = c.PRODUCT_ATTR_CODE
323: AND a.segment_mapping_column like 'PRICING%'

Line 337: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa

333:
334:
335: -- 4.Pricing Attribute
336: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Pricing Attribute');
337: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
338: SET (PRICING_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
339: (SELECT a.segment_mapping_column,
340: DECODE(a.segment_mapping_column, NULL, null, 'P'),
341: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'005',qipa.ATTRIBUTE_STATUS)

Line 342: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

338: SET (PRICING_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
339: (SELECT a.segment_mapping_column,
340: DECODE(a.segment_mapping_column, NULL, null, 'P'),
341: DECODE(a.segment_mapping_column, NULL, qipa.ATTRIBUTE_STATUS||'005',qipa.ATTRIBUTE_STATUS)
342: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c
343: WHERE b.prc_context_id = a.prc_context_id
344: AND b.prc_context_code = c.PRICING_ATTRIBUTE_CONTEXT
345: AND a.segment_code = c.PRICING_ATTR_CODE
346: AND a.segment_mapping_column like 'PRICING%'

Line 359: UPDATE /+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) / QP_INTERFACE_PRICING_ATTRIBS qipa --7323577

355: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
356:
357: --5. Product_Attr_Value
358: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value1');
359: UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ QP_INTERFACE_PRICING_ATTRIBS qipa --7323577
360: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
361: (SELECT a.inventory_item_id,
362: DECODE(a.inventory_item_id, NULL, null, 'P'),
363: DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)

Line 364: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c

360: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
361: (SELECT a.inventory_item_id,
362: DECODE(a.inventory_item_id, NULL, null, 'P'),
363: DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
364: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c
365: WHERE (c.product_attr_value IS NULL and
366: a.concatenated_segments= c.product_attr_val_disp
367: OR c.product_attr_value IS NOT NULL and
368: a.inventory_item_id = c.product_attr_value)

Line 379: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa

375: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
376:
377: --6. Product_Attr_Value
378: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value2');
379: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
380: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
381: (SELECT a.category_id,
382: DECODE(a.category_id, NULL, null, 'P'),
383: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)

Line 384: FROM qp_item_categories_v a, qp_interface_pricing_attribs c

380: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
381: (SELECT a.category_id,
382: DECODE(a.category_id, NULL, null, 'P'),
383: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
384: FROM qp_item_categories_v a, qp_interface_pricing_attribs c
385: WHERE (c.product_attr_value IS NULL and
386: a.category_name = c.product_attr_val_disp
387: OR c.product_attr_value IS NOT NULL and
388: a.category_id = c.product_attr_value)

Line 488: UPDATE QP_INTERFACE_PRICING_ATTRIBS

484:
485: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
486: IF l_product_attr_value IS NULL THEN
487: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
488: UPDATE QP_INTERFACE_PRICING_ATTRIBS
489: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
490: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
491: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
492: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 494: UPDATE QP_INTERFACE_PRICING_ATTRIBS

490: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
491: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
492: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
493: ELSE
494: UPDATE QP_INTERFACE_PRICING_ATTRIBS
495: SET PRODUCT_ATTR_VALUE = l_product_attr_value
496: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
497: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
498: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 502: UPDATE QP_INTERFACE_PRICING_ATTRIBS

498: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
499: END IF;
500: EXCEPTION
501: WHEN OTHERS THEN
502: UPDATE QP_INTERFACE_PRICING_ATTRIBS
503: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
504: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
505: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
506: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 592: UPDATE QP_INTERFACE_PRICING_ATTRIBS

588: l_pricing_attr_value_from := x_value;
589: END IF;
590:
591: qp_bulk_loader_pub.write_log('pricing_attr_value_from is '||l_pricing_attr_value_from);
592: UPDATE QP_INTERFACE_PRICING_ATTRIBS
593: SET PRICING_ATTR_VALUE_FROM = l_pricing_attr_value_from
594: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
595: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
596: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 600: UPDATE QP_INTERFACE_PRICING_ATTRIBS

596: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: UPDATE QP_INTERFACE_PRICING_ATTRIBS
601: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'006'
602: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
603: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
604: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 640: UPDATE QP_INTERFACE_PRICING_ATTRIBS

636: l_pricing_attr_value_to := x_value;
637: END IF;
638:
639: qp_bulk_loader_pub.write_log('pricing_attr_value_to is '||l_pricing_attr_value_to);
640: UPDATE QP_INTERFACE_PRICING_ATTRIBS
641: SET PRICING_ATTR_VALUE_TO = l_pricing_attr_value_to
642: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
643: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
644: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 648: UPDATE QP_INTERFACE_PRICING_ATTRIBS

644: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
645:
646: EXCEPTION
647: WHEN OTHERS THEN
648: UPDATE QP_INTERFACE_PRICING_ATTRIBS
649: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'007'
650: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
651: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
652: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 874: 'QP_INTERFACE_PRICING_ATTRIBS' table_name

870: orig_sys_pricing_attr_ref orig_attr_ref,
871: attribute_status, product_attr_code pac, product_attribute pa,
872: pricing_attr_code pcac, pricing_attribute pca,
873: product_attr_value pav, product_attr_val_disp pavd,
874: 'QP_INTERFACE_PRICING_ATTRIBS' table_name
875: FROM qp_interface_pricing_attribs
876: WHERE request_id = p_request_id
877: AND process_status_flag is null;
878: -- AND attribute_status IS NOT NULL;

Line 875: FROM qp_interface_pricing_attribs

871: attribute_status, product_attr_code pac, product_attribute pa,
872: pricing_attr_code pcac, pricing_attribute pca,
873: product_attr_value pav, product_attr_val_disp pavd,
874: 'QP_INTERFACE_PRICING_ATTRIBS' table_name
875: FROM qp_interface_pricing_attribs
876: WHERE request_id = p_request_id
877: AND process_status_flag is null;
878: -- AND attribute_status IS NOT NULL;
879: