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 361: /* UPDATE /+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) / /*QP_INTERFACE_PRICING_ATTRIBS qipa --7323577

357: --5. Product_Attr_Value
358: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value1');
359: --Query is commented for bug 10065970 smbalara
360:
361: /* UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ /*QP_INTERFACE_PRICING_ATTRIBS qipa --7323577
362: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
363: (SELECT a.inventory_item_id,
364: DECODE(a.inventory_item_id, NULL, null, 'P'),
365: DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)

Line 366: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c

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

Line 380: UPDATE /+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) / QP_INTERFACE_PRICING_ATTRIBS QIPA

376: AND qipa.product_attribute_context='ITEM'
377: AND qipa.product_attribute = 'PRICING_ATTRIBUTE1'
378: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');*/
379:
380: UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ QP_INTERFACE_PRICING_ATTRIBS QIPA
381: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS) =
382: (
383: SELECT A.INVENTORY_ITEM_ID, DECODE(A.INVENTORY_ITEM_ID, NULL, NULL, 'P'),
384: DECODE(INVENTORY_ITEM_ID, NULL,QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)

Line 410: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa

406:
407:
408: --6. Product_Attr_Value
409: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value2');
410: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
411: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
412: (SELECT a.category_id,
413: DECODE(a.category_id, NULL, null, 'P'),
414: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)

Line 415: FROM qp_item_categories_v a, qp_interface_pricing_attribs c

411: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
412: (SELECT a.category_id,
413: DECODE(a.category_id, NULL, null, 'P'),
414: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
415: FROM qp_item_categories_v a, qp_interface_pricing_attribs c
416: WHERE (c.product_attr_value IS NULL and
417: a.category_name = c.product_attr_val_disp
418: OR c.product_attr_value IS NOT NULL and
419: a.category_id = c.product_attr_value)

Line 519: UPDATE QP_INTERFACE_PRICING_ATTRIBS

515:
516: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
517: IF l_product_attr_value IS NULL THEN
518: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
519: UPDATE QP_INTERFACE_PRICING_ATTRIBS
520: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
521: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
522: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
523: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 525: UPDATE QP_INTERFACE_PRICING_ATTRIBS

521: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
522: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
523: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
524: ELSE
525: UPDATE QP_INTERFACE_PRICING_ATTRIBS
526: SET PRODUCT_ATTR_VALUE = l_product_attr_value
527: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
528: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
529: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 533: UPDATE QP_INTERFACE_PRICING_ATTRIBS

529: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
530: END IF;
531: EXCEPTION
532: WHEN OTHERS THEN
533: UPDATE QP_INTERFACE_PRICING_ATTRIBS
534: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
535: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
536: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
537: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 623: UPDATE QP_INTERFACE_PRICING_ATTRIBS

619: l_pricing_attr_value_from := x_value;
620: END IF;
621:
622: qp_bulk_loader_pub.write_log('pricing_attr_value_from is '||l_pricing_attr_value_from);
623: UPDATE QP_INTERFACE_PRICING_ATTRIBS
624: SET PRICING_ATTR_VALUE_FROM = l_pricing_attr_value_from
625: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
626: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
627: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 631: UPDATE QP_INTERFACE_PRICING_ATTRIBS

627: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: UPDATE QP_INTERFACE_PRICING_ATTRIBS
632: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'006'
633: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
634: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
635: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 671: UPDATE QP_INTERFACE_PRICING_ATTRIBS

667: l_pricing_attr_value_to := x_value;
668: END IF;
669:
670: qp_bulk_loader_pub.write_log('pricing_attr_value_to is '||l_pricing_attr_value_to);
671: UPDATE QP_INTERFACE_PRICING_ATTRIBS
672: SET PRICING_ATTR_VALUE_TO = l_pricing_attr_value_to
673: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
674: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
675: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 679: UPDATE QP_INTERFACE_PRICING_ATTRIBS

675: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
676:
677: EXCEPTION
678: WHEN OTHERS THEN
679: UPDATE QP_INTERFACE_PRICING_ATTRIBS
680: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'007'
681: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
682: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
683: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;

Line 905: 'QP_INTERFACE_PRICING_ATTRIBS' table_name

901: orig_sys_pricing_attr_ref orig_attr_ref,
902: attribute_status, product_attr_code pac, product_attribute pa,
903: pricing_attr_code pcac, pricing_attribute pca,
904: product_attr_value pav, product_attr_val_disp pavd,
905: 'QP_INTERFACE_PRICING_ATTRIBS' table_name
906: FROM qp_interface_pricing_attribs
907: WHERE request_id = p_request_id
908: AND process_status_flag is null;
909: -- AND attribute_status IS NOT NULL;

Line 906: FROM qp_interface_pricing_attribs

902: attribute_status, product_attr_code pac, product_attribute pa,
903: pricing_attr_code pcac, pricing_attribute pca,
904: product_attr_value pav, product_attr_val_disp pavd,
905: 'QP_INTERFACE_PRICING_ATTRIBS' table_name
906: FROM qp_interface_pricing_attribs
907: WHERE request_id = p_request_id
908: AND process_status_flag is null;
909: -- AND attribute_status IS NOT NULL;
910: