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.

[Home] [Help]

APPS.OE_ITORD_UTIL dependencies on OE_ITEM_ORDERABILITY

Line 406: From oe_item_orderability hdr,

402:
403: begin
404:
405: select 'Y' into l_exists
406: From oe_item_orderability hdr,
407: oe_item_orderability_rules rules
408: Where hdr.orderability_id = rules.orderability_id
409: and hdr.generally_available='Y'
410: and hdr.org_id = l_operating_unit_id

Line 407: oe_item_orderability_rules rules

403: begin
404:
405: select 'Y' into l_exists
406: From oe_item_orderability hdr,
407: oe_item_orderability_rules rules
408: Where hdr.orderability_id = rules.orderability_id
409: and hdr.generally_available='Y'
410: and hdr.org_id = l_operating_unit_id
411: and hdr.enable_flag = 'Y'

Line 441: From oe_item_orderability hdr,

437:
438: begin
439:
440: select 'Y' into l_exists
441: From oe_item_orderability hdr,
442: oe_item_orderability_rules rules
443: Where hdr.orderability_id = rules.orderability_id
444: and hdr.generally_available='N'
445: and hdr.org_id = l_operating_unit_id

Line 442: oe_item_orderability_rules rules

438: begin
439:
440: select 'Y' into l_exists
441: From oe_item_orderability hdr,
442: oe_item_orderability_rules rules
443: Where hdr.orderability_id = rules.orderability_id
444: and hdr.generally_available='N'
445: and hdr.org_id = l_operating_unit_id
446: and hdr.enable_flag = 'Y'

Line 471: From oe_item_orderability hdr

467: --This is to handle the inclusion rule case where only item orderablility header is defined but no rules are defined
468: --Item is generally not available in all cases(since no rule is defeined in detail block)
469:
470: select 'Y' into l_exists
471: From oe_item_orderability hdr
472: where hdr.generally_available='N'
473: and hdr.org_id = l_operating_unit_id
474: and hdr.enable_flag = 'Y'
475: and (hdr.inventory_item_id = p_line_rec.inventory_item_id or hdr.item_category_id = l_x_item_category_id )

Line 541: From oe_item_orderability hdr,

537:
538: begin
539:
540: select 'Y' into l_exists
541: From oe_item_orderability hdr,
542: oe_item_orderability_rules rules
543: Where hdr.orderability_id = rules.orderability_id
544: and hdr.generally_available='Y'
545: and hdr.org_id = p_org_id

Line 542: oe_item_orderability_rules rules

538: begin
539:
540: select 'Y' into l_exists
541: From oe_item_orderability hdr,
542: oe_item_orderability_rules rules
543: Where hdr.orderability_id = rules.orderability_id
544: and hdr.generally_available='Y'
545: and hdr.org_id = p_org_id
546: and hdr.enable_flag = 'Y'

Line 576: From oe_item_orderability hdr,

572:
573: begin
574:
575: select 'Y' into l_exists
576: From oe_item_orderability hdr,
577: oe_item_orderability_rules rules
578: Where hdr.orderability_id = rules.orderability_id
579: and hdr.generally_available='N'
580: and hdr.org_id = p_org_id

Line 577: oe_item_orderability_rules rules

573: begin
574:
575: select 'Y' into l_exists
576: From oe_item_orderability hdr,
577: oe_item_orderability_rules rules
578: Where hdr.orderability_id = rules.orderability_id
579: and hdr.generally_available='N'
580: and hdr.org_id = p_org_id
581: and hdr.enable_flag = 'Y'

Line 603: From oe_item_orderability hdr

599: Exception
600: when no_data_found then
601: begin
602: select 'Y' into l_exists
603: From oe_item_orderability hdr
604: where hdr.generally_available='N'
605: and hdr.org_id = p_org_id
606: and hdr.enable_flag = 'Y'
607: and (hdr.inventory_item_id = p_inventory_item_id or hdr.item_category_id = l_x_item_category_id )

Line 644: INSERT INTO OE_ITEM_ORDERABILITY

640: BEGIN
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: INSERT INTO OE_ITEM_ORDERABILITY
645: (
646: orderability_id,
647: org_id,
648: item_level,

Line 682: ,'Insert_Row - OE_ITEM_ORDERABILITY'

678:
679: OE_MSG_PUB.Add_Exc_Msg
680: (
681: G_PKG_NAME
682: ,'Insert_Row - OE_ITEM_ORDERABILITY'
683: );
684:
685: END;
686:

Line 696: UPDATE OE_ITEM_ORDERABILITY

692: BEGIN
693:
694: x_return_status := FND_API.G_RET_STS_SUCCESS;
695:
696: UPDATE OE_ITEM_ORDERABILITY
697: SET item_level = p_item_orderability_rec.item_level,
698: item_category_id = p_item_orderability_rec.item_category_id,
699: inventory_item_id = p_item_orderability_rec.inventory_item_id,
700: generally_available = p_item_orderability_rec.generally_available,

Line 718: ,'Update_Row - OE_ITEM_ORDERABILITY'

714:
715: OE_MSG_PUB.Add_Exc_Msg
716: (
717: G_PKG_NAME
718: ,'Update_Row - OE_ITEM_ORDERABILITY'
719: );
720:
721: END;
722:

Line 734: INSERT INTO OE_ITEM_ORDERABILITY_RULES

730: BEGIN
731:
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: INSERT INTO OE_ITEM_ORDERABILITY_RULES
735: (
736: ORDERABILITY_ID,
737: RULE_LEVEL,
738: CUSTOMER_ID,

Line 827: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'

823:
824: OE_MSG_PUB.Add_Exc_Msg
825: (
826: G_PKG_NAME
827: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'
828: );
829:
830: END;
831:

Line 842: UPDATE OE_ITEM_ORDERABILITY_RULES

838: BEGIN
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: UPDATE OE_ITEM_ORDERABILITY_RULES
843: SET RULE_LEVEL = p_item_orderability_rules_rec.RULE_LEVEL,
844: CUSTOMER_ID = p_item_orderability_rules_rec.CUSTOMER_ID,
845: CUSTOMER_CLASS_ID = p_item_orderability_rules_rec.CUSTOMER_CLASS_ID,
846: CUSTOMER_CATEGORY_CODE = p_item_orderability_rules_rec.CUSTOMER_CATEGORY_CODE,

Line 893: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'

889:
890: OE_MSG_PUB.Add_Exc_Msg
891: (
892: G_PKG_NAME
893: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'
894: );
895:
896: END;
897: